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

148 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
pimplier144541(None) 
dimplier1336671dimplier
complier14310252complier
gimpier12247942gimp_ier
implied1238622_implied
implies11312122_implies
limpsier1234432limpsier
pimple123512962pimpl_e_
pimpled14289192pimpl_ed
pimples133012422pimpl_es
pimpliest1545482pimpliest
pipier104913982pi_p_ier
ripplier1234462ripplier
rumplier1235302rumplier
simpler112910862simpl_er
timelier1036712timelier
wimpier14248052wimp_ier
ampler104313303_ampl_er
animalier1145933animalier
applier1137903_applier
bumpier13359203bump_ier
campier133313273camp_ier
comelier12310653comelier
compiler1438373compiler
complied1539683complied
compliers1538293compliers
complies14314523complies
crimpier14287323crimp_ier
crumplier1543783crumplier
dimple113512793dimpl_e_
dimpled132810303dimpl_ed
dimples122813213dimpl_es
dimpliest1436583dimpliest
dimpling14199023dimpling
dippier123111393di_ppier
dumpier12409653dump_ier
emptier1187603_emptier
gigglier1154323gigglier
girlier8289523gi_rlier
hempier14319003hemp_ier
hillier103413963hi_llier
hippier143212103hi_ppier
homelier1338983homelier
humpier143110723hump_ier
impair1036003_impai_r
impairer1244863_impairer
impaler11298393_impaler
impeder12438533_impeder
impeller1236083_impeller
impled113812513_impl_ed
implore11176703_implore
implorer12125103_implorer
imposer113310103_imposer
impower14247123_impower
impurer1136483_impurer
imputer1136533_imputer
inlier63615363_i_nlier
jigglier1754093jigglier
jimper17389863jimp__er
jinglier1655233jinglier
jumpier18317943jump_ier
kindlier1345763kindlier
kinglier1345633kinglier
likelier1235283likelier
limbier11349113lim_bier
limier83518723lim__ier
limper104117853limp__er
lippier112710573li_ppier
livelier1136873livelier
lumpier113410143lump_ier
millier93716703mi_llier
nigglier1044843nigglier
nimbler11358063nimbl_er
nippier11319833ni_ppier
oilier64417233oi__lier
palier85023563p__alier
pallier94417163p_allier
pamper124316663pamp__er
pamperer14228333pamperer
pappier103511603p_appier
pearlier1037323pearlier
pebblier1453263pebblier
pedalier1137603pedalier
peopler1138083peopl_er
peppier10268323p_eppier
pickier153912973pi_ckier
piddler112911523piddl_er
piggier113510003pi_ggier
pilfer1139163pi__lfer
pimped134913483pimp__ed
pimping143812123pimp_ing
pimply15329213pimpl__y
pinier84024693pi__nier
piper96523193pi_p__er
pistolier1146383pistolier
pitchier15368273pitchier
pithier123010293pi_thier
pitier84019823pi__tier
plier75221283___plier
portlier1038373portlier
preppier1156643preppier
pricklier17245063pricklier
puddlier1234213puddlier
pulpier1148623pulp_ier
pumper124415553pump__er
pumplike1834373pumplike
purpler11289273purpl_er
replier94214973_replier
rimier83916273rim__ier
rimple103814583rimpl_e_
rimpled123311423rimpl_ed
rimples113114223rimpl_es
rimpling13219663rimpling
rippler113210103rippl_er
sampler113212013sampl_er
sicklier1457213sicklier
sillier74017593si_llier
simper103616293simp__er
simperer1237173simperer
simple104315173simpl_e_
simples113014943simpl_es
simplex18256393simpl_ex
simplices1546043simplices
simplifier1753103simplifier
simplify1843553simplify
simplism14216243simplism
simplist12249683simplist
skimpier1634293skimp_ier
slimpsier1343023slimpsier
spindlier1253873spindlier
supplier1246603supplier
tinglier956403tinglier
tinklier1255443tinklier
tippier113210543ti_ppier
tippler11348343tippl_er
tipsier9268893ti_psier
vampier14308233vamp_ier
wamblier15275733wamblier
wifelier1434853wifelier
wigglier1354453wigglier
wilier93217073wi__lier
wimple133611363wimpl_e_
wimpled15338823wimpl_ed
wimples143311173wimpl_es
wimpling16207483wimpling
wiselier1137363wiselier
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.420425454.8
2DLD Change Limit1461621487.06320694.0
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.54623680.2
 
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.