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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
killdees137396(None) 
killdee1266221killdee_
killdeer1362941killdeer
killdeers1462451killdeers
killers114215582kill_ers
killies113318112kill_ies
allees64521483_all_ees
billers94720833bill_ers
billets94516153bill_ets
billies93923503bill_ies
callees94117783call_ees
dildoes9229243di_ldoes
dillies84122163dill_ies
fielders12156773fielders
filarees1187643filarees
fillers104320213fill_ers
filles94224523fill__es
fillets103414753fill_ets
fillies103420253fill_ies
gilders94212463gi_lders
gillers84216903gill_ers
gillies84120963gill_ies
gillnets934733gillnets
hillers103718733hill_ers
hilloes103815963hill_oes
illites72415013_illites
illness736473_illness
illudes8347553_illudes
illumes9327673_illumes
kellies113516853kell_ies
kidders13399173ki_dders
kiddies133412283ki_ddies
kiddoes13387063ki_ddoes
killed113918773kill__ed
killer104917953kill__er
killicks1354873killicks
killie104114893kill_ie_
killings133710483killings
killjoys2242033killjoys
killocks1354793killocks
kills94526183kill___s
kilters113813603ki_lters
kilties113014143ki_lties
kimchees1942943kimchees
kindlers13318483kindlers
kindles123614843ki_ndles
kindless13289243kindless
kinless113310273kinl_ess
kludges13397703k_ludges
mallees93315973mall_ees
miladies1139923miladies
mildens10339933mi_ldens
mildews13365883mi_ldews
millages113212903millages
milldams1344633milldams
millers93621343mill_ers
milles84526563mill__es
millets94216843mill_ets
milliemes13255843milliemes
milliers102611903milliers
millimes122411373millimes
millines102718063millines
pillages113012613pillages
pollees93215333poll_ees
rilles64725503rill__es
rillets74216153rill_ets
sillers73822103sill_ers
sillies73425083sill_ies
skilless12246763skill_ess
skillets12226823skill_ets
tildes74513963ti_ld_es
tillages93011263tillages
tillers73418743till_ers
tillites8312833tillites
villages123010603villages
wielders12196613wielders
wilders113513503wi_lders
willers103517913will_ers
willets104414323will_ets
willies103920153will_ies
yielders12164743yielders

Search took 7 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 Limit146162816.33023090.4
3Display Results81810.0302700.0
 (SQL Overall)178691816.78026355.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.