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

128 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
zippered2224482(None) 
kippered17255621kippered
lippered13287951lippered
chippered1945002chippered
ciphered1637052ciphered
coppered153410542coppered
diapered1238002diapered
kipperer16294722kipperer
lappered13288212lappered
lippened13255222lippened
loppered13326752loppered
peppered1236112peppered
simpered1338252simpered
skippered1843422skippered
slippered1434822slippered
zipped203612982zipp__ed
zipper193813122zipper__
zippers203310372zipper_s
appeared1336143_appeared
bickered17108003bickered
bistered112913323bistered
bittered112711833bittered
bumpered1536003bumpered
capered123014043_capered
choppered1964883choppered
cindered1239793cindered
cipherer1545573cipherer
compered153414923compered
coopered133310933coopered
cyphered1934653cyphered
dapperer1335763dapperer
dickered16117533dickered
differed1635523differed
dipped123517493dipp__ed
dipper114017783dipper__
dippers123615173dipper_s
dispersed13119773dispersed
dithered13189293dithered
fibered1337643fi_bered
filtered12259043filtered
fingered13128323fingered
gibbered1444303gibbered
gingered11127733gingered
gipped124815903gipp__ed
gipper114215303gipper__
gippers123212073gipper_s
hampered16239923hampered
happened1635653happened
hindered1339453hindered
hipped144317693hipp__ed
hipper133818023hipper__
impeded13418183_impeded
inhered11313163_inhered
jiggered1834203jiggered
jittered16267223jittered
kipped153114573kipp__ed
kipper143414203kipper__
kipperers17233823kipperers
kippers153211423kipper_s
lappeted13255833lappeted
limbered13158113limbered
lingered10129633lingered
lipped114419543lipp__ed
lipper104219633lipper__
lippers113416433lipper_s
littered92511383littered
livered113111633li_vered
mitered103213233mi_tered
nickered15117023nickered
niffered1544143niffered
nipped113615853nipp__ed
nipper103715713nipper__
nippers113012613nipper_s
nippled12307643nipp_led
pampered15229223pampered
papered122513163_papered
paupered13216933paupered
peered93819483__peered
pepperer1145273pepperer
pilfered1435853pilfered
pipped104516543pipp__ed
rapiered1136053rapiered
rappeled1335003rappeled
repapered1445233repapered
ripened1038203ri_pened
ripped114419013ripp__ed
ripper103518653ripper__
rippers114115023ripper_s
rippled123110273ripp_led
scuppered1643933scuppered
silvered12237563silvered
simmered1336863simmered
simperer1237173simperer
sintered92213903sintered
sipped113720633sipp__ed
sipper103920983sipper__
sippers113117743sipper_s
sistered92612803sistered
speered103614813_speered
sphered133512313_sphered
spiered104412463_spiered
stoppered1444463stoppered
supered10316123_supered
syphered1755013syphered
tampered13279463tampered
tapered102612933_tapered
tempered13248213tempered
tiered73613973ti__ered
tillered937433tillered
timbered13137383timbered
tinkered1387683tinkered
tipped114418263tipp__ed
tipper103918413tipper__
tippers113414343tipper_s
tippled12358393tipp_led
tittered9239493tittered
whimpered20144023whimpered
whispered18144373whispered
wildered1336633wildered
wintered122111573wintered
withered15169433withered
yipped143613283yipp__ed
yippee132810743yippe_e_
zapped204213523zapp__ed
zapper193414023zapper__
zappers203911633zapper_s
zippering23215193zippering
zippier20308193zipp_ier

Search took 9 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.1731032896.0
2DLD Change Limit1461621288.09618053.6
3Display Results1281280.0432976.7
 (SQL Overall)1786911288.31221498.0
 
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.