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 “limpsier” 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.

112 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
limpsier123443(None) 
slimpsier1343021slimpsier
dimplier1336672dimplier
flimsier1344132flim_sier
gimpier12247942gimp_ier
glimpser1342662glimps_er
limbier11349112lim_bier
limier83518722lim__ier
limper104117852limp__er
limpsey14365092limps_ey
limpsiest1344792limpsiest
lippier112710572li_ppier
lumpier113410142lump_ier
pimplier1445412pimplier
slimsier1085212slim_sier
tipsier9268892ti_psier
wimpier14248052wimp_ier
bimester1236163bimester
biopsied1344593biopsied
biopsies1237383biopsies
bitsier9379073bi_tsier
bumpier13359203bump_ier
campier133313273camp_ier
clumpier1435583clump_ier
clumsier1234733clum_sier
complier14310253complier
crimpier14287323crimp_ier
dempster1355773dempster
dippier123111393di_ppier
ditsier83010293di_tsier
dumpier12409653dump_ier
dumpster1344053dumpster
emptier1187603_emptier
flimsies1335783flim_sies
gipsied1135873gi_psied
gipsies1039903gi_psies
glimpse1233763glimps_e_
glimpsed1442773glimps_ed
glimpsers1442193glimps_ers
glimpses1343953glimps_es
glimpsing1542593glimpsing
glumpier1334873glump_ier
hempier14319003hemp_ier
hippier143212103hi_ppier
hipster12288783hi_pster
hissier103410503hi_ssier
humpier143110723hump_ier
impair1036003_impai_r
impairer1244863_impairer
impaler11298393_impaler
impeder12438533_impeder
implied1238623_implied
implies11312123_implies
imposer113310103_imposer
imposter12288163_imposter
impower14247123_impower
impurer1136483_impurer
imputer1136533_imputer
jimper17389863jimp__er
jumpier18317943jump_ier
lambier113611643lam_bier
lamister1037653lamister
lamster9109913lam_ster
lapser84113143l_aps_er
likelier1235283likelier
limber104316793lim__ber
limberer12187053limberer
limiter92710853lim_iter
limmer104314793lim__mer
limner84112873lim__ner
limped114817123limp__ed
limpers113815223limp__ers
limpet103518633limp__et
limpid11389753limp_i_d
limping124614113limp_ing
limpkin1534223limpki_n
limpkins1644233limpkins
limps95522673limps___
limpsy13516843limps__y
lingier84113383li_ngier
linier64423793li__nier
lintier73613803li_ntier
lioniser845583lioniser
lipper104219633li_p_per
lisper84114433li__sper
lister64527253li__ster
livelier1136873livelier
livier97514593li__vier
loopier93711193loop_ier
loppier11369723l_oppier
lousier72411623l_ousier
lumper103816653lump__er
nippier11319833ni_ppier
pipier104913983pi_p_ier
rimester1037813rimester
rimier83916273rim__ier
ripplier1234463ripplier
rumplier1235303rumplier
simper103616293simp__er
simperer1237173simperer
simpler112910863simp_ler
sissier73711363si_ssier
skimpier1634293skimp_ier
slimier93212013slim__ier
slimpsiest1443033slimpsiest
slippier1256533sli_ppier
timelier1036713timelier
tippier113210543ti_ppier
tipster9299053ti_pster
vampier14308233vamp_ier
wispier12249403wisp_ier
zippier20308193zi_ppier

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621127.48619524.7
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.