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

134 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
kippered1725562(None) 
kipperer16294721kipperer
lippered13287951lippered
skippered1843431skippered
zippered22244821zippered
chippered1945002chippered
ciphered1637052ciphered
coppered153410542coppered
diapered1238002diapered
kipped153114572kipp__ed
kipper143414212kipper__
kipperers17233822kipperers
kippers153211432kipper_s
lappered13288212lappered
lippened13255222lippened
loppered13326752loppered
peppered1236122peppered
simpered1338252simpered
slippered1434822slippered
appeared1336143_appeared
bickered17108003bickered
bistered112913323bistered
bittered112711833bittered
bumpered1536003bumpered
capered123014043_capered
choppered1964883choppered
cindered1239793cindered
cipherer1545573cipherer
compered153414923compered
coopered133310933coopered
cyphered1934653cyphered
dapperer1335763dapperer
dickered16117533dickered
differed1635523differed
dipped123517493dipp__ed
dipper114017793dipper__
dippers123615183dipper_s
dispersed13119783dispersed
dithered13189293dithered
fibered1337643fi_bered
filtered12259043filtered
fingered13128333fingered
gibbered1444303gibbered
gingered11127743gingered
gipped124815903gipp__ed
gipper114215303gipper__
gippers123212083gipper_s
hampered16239933hampered
happened1635653happened
hindered1339453hindered
hipped144317693hipp__ed
hipper133818023hipper__
impeded13418183_impeded
inhered11313163_inhered
jiggered1834203jiggered
jittered16267223jittered
kashered1636403kashered
kepped15309533kepp__ed
kindred13316953ki_ndred
kippen14299013kipp__en
kippering18205443kippering
kittened1334523kittened
koshered1636063koshered
lappeted13255833lappeted
limbered13158123limbered
lingered10129643lingered
lipped114419543lipp__ed
lipper104219633lipper__
lippers113416443lipper_s
littered92511383littered
livered113111633li_vered
mitered103213233mi_tered
nickered15117023nickered
niffered1544143niffered
nipped113615853nipp__ed
nipper103715713nipper__
nippers113012623nipper_s
nippled12307643nipp_led
pampered15229223pampered
papered122513163_papered
paupered13216933paupered
peered93819483__peered
pepperer1145273pepperer
pilfered1435853pilfered
pipped104516543pipp__ed
rapiered1136053rapiered
rappeled1335003rappeled
repapered1445233repapered
ripened1038203ri_pened
ripped114419013ripp__ed
ripper103518653ripper__
rippers114115033ripper_s
rippled123110273ripp_led
scuppered1643933scuppered
silvered12237563silvered
simmered1336863simmered
simperer1237173simperer
sintered92213903sintered
sipped113720633sipp__ed
sipper103920993sipper__
sippers113117753sipper_s
sistered92612803sistered
skipped16358413skipp__ed
skipper15339573skipper__
skippers16318203skipper_s
skittered1434633skittered
speered103614813_speered
sphered133512313_sphered
spiered104412463_spiered
stoppered1444473stoppered
supered10316123_supered
syphered1755013syphered
tampered13279463tampered
tapered102612933_tapered
tempered13248213tempered
tiered73613973ti__ered
tillered937443tillered
timbered13137383timbered
tinkered1387683tinkered
tipped114418263tipp__ed
tipper103918413tipper__
tippers113414353tipper_s
tippled12358393tipp_led
tittered9239493tittered
whimpered20144023whimpered
whispered18144373whispered
wildered1336633wildered
wintered122111573wintered
withered15169433withered
yipped143613283yipp__ed
yippee132810743yippe_e_
zipped203612983zipp__ed
zipper193813123zipper__
zippers203310383zipper_s

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.1561145455.1
2DLD Change Limit1461621347.86018595.7
3Display Results1341340.0632127.0
 (SQL Overall)1786911348.07922118.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.