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

118 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
delimit1031173(None) 
delimits1137571delimits
deficit1339682deficit
delict94320332deli_ct
delight12610672delight
delime9314042delim_e
delimed11310722delimed
delimes10314192delimes
deliming12310372deliming
delimited1346592delimited
delimiter1246242delimiter
deliria868312deliria
delist74625052deli_st
demit84832302de__mit
elicit8417202_elicit
limit73126342__limit
prelimit1259122prelimit
bevomit1445353bevomit
bulimia1145043bulimia
bulimic1345143bulimic
daimio937463d_aimio
dammit11311133d_ammit
debility1448643debility
debit85727853de__bit
deceit93018213de_ceit
decimal1238083decimal
decimate13411123decimate
declinist1247653declinist
declivity1844493declivity
defiant11311923defiant
deficits1447283deficits
definite1239333definite
degami10279013degami_
degamis11268443degamis
deific1237313de_ific
deist64633593de_i_st
deixis1437243de_ixis
delft95623323del__ft
deli55631293del__i_
delicate11315493delicate
delicts104012253delicts
delights1347333delights
delimiters1345103delimiters
delimiting1445843delimiting
delirium1146583delirium
delis64928543del__is
delish105215613deli_sh
delists84414173delists
deliver113312243deliver
delphic1545103delphic
delt57855273del___t
deltaic1037023deltaic
deltic9312503del_tic
deltoid938573deltoid
demerit10314993demerit
demic105119193de__mic
demits94918073de__mits
denim85518843denim__
denimed1159233denimed
denims95214323denim_s
deorbit1048173deorbit
depict113514793depi_ct
deposit10313003deposit
dermic114511913de_rmic
dermis94717163de_rmis
desist74818813desi_st
desmid1048363de_smid
deviant11311313deviant
dewiest11312343dewiest
digit73825273d__igit
dimity12310483d__imity
dimwit1237953d__imwit
dixit134420593d__ixit
dolomite1148133dolomite
duelist8511413dueli_st
eeliest73516473eeliest
elegit71212893_elegit
elemi7312503_elemi_
elemis8312383_elemis
elicits9311233_elicits
elint55436473_eli_nt
elitist7414913_elitist
elixir1333703_elixir
emit65438423_e__mit
felicity1647923felicity
felinity1447293felinity
gelidity1345573gelidity
heliast10312073heliast
helicity1648503helicity
helilift1445183helilift
helmet113718933hel_met
hermit11519443he_rmit
illicit949833illicit
kelim11912553kelim__
kelims1278913kelim_s
licit74327683__licit
limits82514143__limits
melilite10410573melilite
melilot9311083melilot
melinite10411753melinite
pelitic111814653pelitic
pelmet103419243pel_met
permit10321683pe_rmit
prelimits1366013prelimits
readmit1039823readmit
reemit8717223re_emit
reliant7319243reliant
relict83623903reli_ct
relight11512063relight
relist64628413reli_st
relit55340683rel__it
remit75737223re__mit
revisit10311373revisit
semifit1249973semifit
semimat11412913semimat
solicit9315743solicit
sublimit1247513sublimit
telomic1147603telomic

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271187.15618729.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.60823487.3
 
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.