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

99 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
halakic165666(None) 
halakhic2043311halakhic
hagadic1445862hagadic
halachic1865652halachic
halakah17517962halakah
halakha17416582halakha
halakist15158222halakist
jalapic1844542jalapic
thalamic1545552thalamic
agamic113110563_agamic
agaric93513633_agaric
alanin6317273_alanin
alcaic1039983_alcaic
alfaki1385383_alfaki_
alfakis1475073_alfakis
alkalic13146973_alkalic
alkie95520033_al_kie
arabic10312733_arabic
atavic11189293_atavic
ataxic15169203_ataxic
baldric12166403baldric
balladic1345333balladic
balsamic1463803balsamic
calami10313423calami_
calcic9311873cal_cic
calkin123515493cal_kin
caloric113413223caloric
canakin131810833canakin
chalazia2245133chalazia
dalasi7610623dalasi_
dalasis8810533dalasis
dalmatic1348683dalmatic
fanatic12610693fanatic
faradic1337693faradic
galabia1038323galabia
galactic13106533galactic
galenic1038693galenic
gallic9411643gal_lic
galvanic1444513galvanic
hackie154615623ha_ckie
hadarim13117453hadarim
haematic151310213haematic
haemic133210083ha_emic
haggadic1643073haggadic
hakim14311833h__akim
halacha15388003halacha
halakahs18426633halakahs
halakhah17384763halakhah
halakhas18386723halakhas
halakhist19153873halakhist
halakhot1884833halakhot
halakists16125353halakists
halakoth1873433halakoth
halal85623593hala__l
halala94715093hala_la
halalah13429393halalah
halalas104214083halalas
halals95018313hala_ls
halation11313853halation
halavah16447023halavah
halid94424983hal__id
haloid104317763hal_oid
hankie133915713ha_nkie
haptic13511893ha_ptic
hawkie163810093ha_wkie
hazanim2164623hazanim
hematic141816743hematic
hepatic141712773hepatic
hexadic2045413hexadic
holmic1338783hol_mic
jalapin1645923jalapin
kulaki984293kulaki_
laic65931563__la_ic
latakia1146093latakia
malaria9313693malaria
malefic1486323malefic
malic94525663mal__ic
malkin122913153mal_kin
manakin131810643manakin
melanic11310403melanic
paladin101011773paladin
palais8420423pala_is
palladic1346113palladic
pelagic1237863pelagic
phallic1447293phal_lic
salami8313103salami_
salamis9313513salamis
salic73424713sal__ic
saluki1036203saluki_
salukis1136033salukis
satanic939933satanic
shamanic1546563shamanic
talaria7412513talaria
talkie103914443tal_kie
thalami1246083thalami_
thalassic1453403thalassic
thallic1246553thal_lic
valeric1238303valeric
vanadic1336743vanadic

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.403443402.0
2DLD Change Limit134027996.89319443.9
3Display Results99990.0462152.2
 (SQL Overall)178691997.34224338.2
 
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.