Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “simplex” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

174 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
simplex1825639(None) 
simple104315171simple_
simpler112910861simpler
simples113014941simples
complex2037242complex
dimple113512792dimple_
dimpled132810302dimpled
dimples122813212dimples
diplex16408052di_plex
impled113812512_impled
pimple123512962pimple_
pimpled14289192pimpled
pimples133012422pimples
rimple103814582rimple_
rimpled123311422rimpled
rimples113114222rimples
sample104215012sample_
sampled123410792sampled
sampler113212012sampler
samples112815452samples
semple103212752semple_
silex123417412si__lex
simile83115632simile_
similes92915232similes
simper103616292simp_er
simplest122310222simplest
simplexes2043992simplexes
simply133010522simpl_y
wimple133611362wimple_
wimpled15338822wimpled
wimples143311172wimples
ample94720303_ample_
ampler104313303_ampler
biflex1834953bi_flex
cimex16119133cim__ex
crimple13408693crimple_
crimpled15366933crimpled
crimples14308963crimples
dimplier1336673dimplier
dimply14339743dimpl_y
duplex16386973_duplex
fimble133611753fimble_
fimbles143510663fimbles
fipple13329063fipple_
fipples14298653fipples
funplex1932833funplex
gimlet93716663gim_let
gimped123911473gimp_ed
gimpier12247943gimpier
hirple11158973hirple_
hirpled13157143hirpled
hirples12149643hirples
ilex115822033_i__lex
impale102811663_impale_
impaled12288513_impaled
impaler11298393_impaler
impales113311763_impales
imped105117983_imp_ed
impel95711773_imp_el
impels10389523_impels
imphee13310353_imphee
implead12315823_implead
implied1238623_implied
implies11312123_implies
imply124911843_impl_y
jimper17389863jimp_er
jimply20397483jimpl_y
limped114817123limp_ed
limper104117853limp_er
limpet103518633limp_et
limply133810033limpl_y
limpsey14365093limpsey
mispled12310463mispled
nimble103412943nimble_
nimbler11358063nimbler
nipple103410373nipple_
nippled12307643nippled
nipples11319663nipples
perplex1836153perplex
pimped134913483pimp_ed
pimplier1445413pimplier
pimply15329213pimpl_y
plex137321373___plex
ripple103413913ripple_
rippled123110273rippled
rippler113210103rippler
ripples113513293ripples
ripplet113412583ripplet
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
samlet84126563sam_let
samplers12299403samplers
scolex1538243s_colex
sempre102710093sempre_
sickle124418323sickle_
sickled144713433sickled
sickles133417543sickles
sidle65124033si_dle_
sidled84215173si_dled
sidler74716963si_dler
sidles74721153si_dles
siller64026063si_ller
silvex16336723si_lvex
similar937853similar
simlin8311733sim_lin
simmer104115353sim_mer
simnel857023sim_nel
simnels976103simnels
simoleon10133093simoleon
simp85228773simp___
simpered1338253simpered
simperer1237173simperer
simpers113014123simpers
simpleton13163033simpleton
simplices1546043simplices
simplify1843553simplify
simplism14216243simplism
simplist12249683simplist
simps94719763simp__s
simular938673simular
single74520603single_
singled93914683singled
singles83520433singles
singlet84120113singlet
sipe67341043si_p_e_
siped84927683si_p_ed
sipes76036953si_p_es
sipped113720633si_pped
sipper103920993si_pper
sippet103519393si_ppet
sizzle14309613sizzle_
sizzled16367883sizzled
sizzler15266863sizzler
sizzles15349633sizzles
skimped16256223skimp_ed
skimpier1634293skimpier
smilax1535393s_milax
smile74823923s_mile_
smiled93716433s_miled
smiler83916683s_miler
smiles84522293s_miles
smiley114012303s_miley
staple84415823staple_
stapled103613703stapled
stapler93913633stapler
staples93617213staples
stipple1146623stipple_
stippled1345303stippled
stippler1235543stippler
stipples1247023stipples
sumpter1138873sumpter
supple10410203supple_
suppled1248463suppled
suppler1148433suppler
supples11511283supples
swiple11379233swiple_
swiples12339643swiples
swipple1444633swipple_
swipples1534843swipples
temple102811333temple_
templed12278563templed
temples112610893temples
templet112712003templet
tipple103411913tipple_
tippled12358393tippled
tippler11348343tippler
tipples112811253tipples
triplex16447803triplex
wimble133211923wimble_
wimbled15298153wimbled
wimbles143010853wimbles
wimped144211513wimp_ed
wimpier14248053wimpier

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271746.89319443.9
3Display Results1741740.0602900.0
 (SQL Overall)1786911747.35924282.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.