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

86 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
halachas1631789(None) 
halacha15388021halacha_
halakhas18386721halakhas
halachic1865662halachic
halachist17136602halachist
halachot1697352halachot
halakahs18426632halakahs
halakha17416592halakha_
halakhah17384762halakhah
halakhahs18393132halakhahs
halalahs14367442halalahs
halalas104214082hala_las
halavahs17415792halavahs
malaccas1445162malaccas
abacas104414723_abac_as
acacias11510403_acacias
alaskas1136683_alaskas
alohas9411703_al_ohas
alpacas1137073_alpac_as
alphas1139513_al_phas
apaches143411843_apaches
balatas9311833bala_tas
calashes13310543calashes
calathos1347533calathos
calathus1345033calathus
caleches15269943caleches
caliches153812273caliches
canchas143212403ca_nchas
chalahs15289883chala_h_s
chalazas2245893chala_zas
clachan1437183_clachan
clachans1546413_clachans
clachs133511323_clach_s
dachas124113253__dachas
datchas1347423da_tchas
earaches13411313earaches
eulachan1353023eulachan
eulachans1452633eulachans
galabias1137733galabias
galahs105512683gala_h_s
galangas1046173galangas
galateas937153galateas
ganaches1437433ganaches
hahas117118443h__a_has
halachists18174433halachists
halachoth16103833halachoth
halakah17517963hala_kah
halakhic2043313halakhic
halakhist19153873halakhist
halakhot1884833halakhot
halala94715093hala_la_
halalah13429393hala_lah
halals95018313hala__ls
halavah16447023hala_vah
hallahs133912463hallah_s
halloas104318463hal_loas
halmas117017893hal__mas
halvahs16417533halvah_s
halvas124714173hal__vas
hamadas1339673hama_das
hatches153420273ha_tches
haunches1656963haunches
hawalas13348353hawa_las
headaches1845033headaches
hibachis1863953hibachis
huaraches1744993huaraches
huarachos1743283huarachos
kwachas1943063_kwachas
laches116528353__laches
malacca1344963malacca_
malangas1136863malangas
malarias10313773malarias
malthas1237913mal_thas
maracas11313773marac_as
nachas114914193__nachas
oolachan13133353oolachan
oolachans14122713oolachans
pachas135017143__pachas
palabras1267353palabras
palaces114216463palac_es
palapas11311493pala_pas
panaceas1236763panaceas
panaches15310293panaches
panochas1545653panochas
patacas11311003patac_as
tamashas13135683tamashas

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 Filter1786911461620.406440125.6
2DLD Change Limit146162866.82621412.5
3Display Results86860.0332606.1
 (SQL Overall)178691867.26524596.1
 
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.