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

91 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
halacha1538800(None) 
halachas16317881halachas
halakha17416581halakha
halachic1865652halachic
halachot1697342halachot
halakah17517962halakah
halakhah17384762halakhah
halakhas18386722halakhas
halala94715092hala_la
halalah13429392halalah
halavah16447022halavah
malacca1344952malacca
abaca95118043_abac_a
acacia10311353_acacia
alack114820063_alac_k
alaska1036713_alaska
aloha8513613_al_oha
alpaca1047383_alpac_a
alpha1049653_al_pha
apache134210773_apache
balata8614673bala_ta
calash11312433calash_
calathi1247583calathi
caleche14297943caleche
caliche14329953caliche
cancha134411613ca_ncha
chalah143511663chala_h_
chalahs15289883chala_hs
chalaza2145733chala_za
chalazia2245133chalazia
clach124617823_clach_
clachan1437183_clachan
clachs133511323_clachs
dacha114812573__dacha
datcha1266563da_tcha
earache1239323earache
eulachan1353023eulachan
galabia1038323galabia
galah95917633gala_h_
galahs105512673gala_hs
galanga936013galanga
galatea839953galatea
ganache1346203ganache
haha107821063h__a_ha
halachist17136603halachist
halachoth16103813halachoth
halakahs18426633halakahs
halakhahs18393133halakhahs
halakhic2043313halakhic
halakhot1884833halakhot
halakic1656663halakic
halal85623593hala__l
halalahs14367443halalahs
halalas104214083halalas
halals95018313hala_ls
halavahs17415793halavahs
hallah124115403hallah_
hallahs133912463hallahs
halloa94918123hal_loa
halma108219253hal__ma
halva115414433hal__va
halvah15499833halvah_
halvahs16417533halvahs
hamada1239923hama_da
hatch135719593ha_tch_
haunch14377343haunch_
hawala12368913hawa_la
headache1744703headache
headachy2043313headachy
hibachi1744203hibachi
huarache1644313huarache
huaracho1643523huaracho
kwacha1832983_kwacha
malaccas1445163malaccas
malanga1036663malanga
malaria9313693malaria
maltha1137503mal_tha
maraca10314153marac_a
oolachan13133353oolachan
pacha126518063__pacha
palabra1137183palabra
palace104516913palac_e
palaced124110773palaced
palaces114216453palaces
palapa10310673pala_pa
panacea1137783panacea
panache1458423panache
panocha1444983panocha
pataca10311193patac_a
talaria7412513talaria
tamasha12125433tamasha

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 Filter1786911340270.1531167915.0
2DLD Change Limit134027916.58020368.8
3Display Results91910.0303033.3
 (SQL Overall)178691916.76326421.9
 
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.