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 “kiefs” with Change Limit: [1] [2]

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

109 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
kiefs12611220(None) 
fiefs116213701fiefs
keefs125116281keefs
kefs115922741k_efs
kief117128391kief_
kiers95320091kiers
kifs116023501ki_fs
alefs87319662alefs
beefs105618562beefs
biers76225222biers
biffs134814402biffs
briefs115510072briefs
chefs136214662chefs
chiefs14509652chiefs
clefs106616242clefs
dies55653522die_s
diets66026642diets
diffs126315482diffs
difs86027322di_fs
efs66829602__efs
fief107331352fief_
fifes114822392fifes
gies55641422gie_s
griefs10418722griefs
hies74842832hie_s
ifs67124242_i_fs
jiffs185710312jiffs
kaes85734062kae_s
kafs116423742k_afs
kaifs125715642kaifs
keas86337092k_eas
keef115829992keef_
keeks84717252keeks
keels94622412keels
keens95721182keens
keeps116020282keeps
keets95123482keets
kef105639662k_ef_
kegs95824012k_egs
keirs95313672keirs
kens85435232k_ens
keps106027302k_eps
kerfs125413572kerfs
keys116322162k_eys
khafs15648842khafs
khets124913432khets
kibeis12469802kibeis
kibes115521112kibes
kicks104420082kicks
kids96029632ki_ds
kier86526802kie_r
kif105941172ki_f_
kikes85122552kikes
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
kinas95626912kinas
kinds106221812kinds
kines95039132kines
kings105825562kings
kinks84926082kinks
kinos96626142kinos
kins85747902ki_ns
kips106430512ki_ps
kirks84915262kirks
kirns95315452kirns
kirs85831732ki_rs
kis78051472ki__s
kiss85227392ki_ss
kists95822112kists
kiters105218582kiters
kites95432542kites
kiths125814972kiths
kits86441762ki_ts
kivas124614732kivas
kiwis12328582kiwis
knees95114872knees
knifes136210212knifes
koels94613902koels
kues86426772kue_s
kyes115124932kye_s
lief76036982lief_
liens56525502liens
liers55130402liers
lies46454192lie_s
lieus56218482lieus
miens76118302miens
miffs134512872miffs
neifs85613042neifs
piers75926332piers
pies66949602pie_s
reefs85121662reefs
refs75732242_refs
reifs84819092reifs
riels55121332riels
riffs115114612riffs
rifs74929002ri_fs
seifs85019332seifs
skiers104713692skiers
skies95026832skie_s
skiffs16327012skiffs
tiers55526522tiers
ties45248312tie_s
tiffs114414882tiffs
viers85621952viers
vies75238622vie_s
views11489642views
wifes114522562wifes

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538001091.98327130.6
3Display Results1091090.0462369.6
 (SQL Overall)1786911092.12284208.8
 
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.