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

67 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
halidoms148582(None) 
halidom1386441halidom_
halidome14115311halidome
halidomes15104861halidomes
halides113416662halid_es
halids104016132halid__s
aldols7109713_al_dols
alidads936293_alidads
aliyos9349533_aliyo_s
amidols10457563_amidols
axioms15408053_axi_oms
calicoes123911603calicoes
calicos113913493calico_s
chilidogs16122773chilidogs
earldoms1144223earldoms
fandoms13229473fa_ndoms
filmdoms1642503filmdoms
galiots82311323gali_ots
galipots1145213galipots
hagdons1258523ha_gdons
hairdos1136823hairdo_s
hakims1537303haki__ms
halcyons1644023halcyons
halibuts1364443halibuts
halid94424983halid___
halide103417993halid__e
halites103221193hali_tes
halitoses1246613halitoses
halitosis1245203halitosis
halitus10339963hali_tus
halloas104318463hal_loas
halloes104021523hal_loes
halloos103716743hal_loos
hallos95425103hal_lo_s
hallows134417393hal_lows
halms105225213hal___ms
haloes94623863hal__oes
haloids113012553haloid__s
halons95720713hal__ons
halos85230253hal__o_s
hangdogs1443603hangdogs
hansoms12238523ha_nsoms
hapkidos1842713hapkido_s
haricots1347333haricots
haviors1347383havi_ors
heirdoms1444353heirdoms
helicons1337613helicons
helios94816633heli_o_s
heliums12188303heli_ums
holidays1544103holidays
holisms123811113holi_sms
humidors1443993humidors
jarldoms1842943jarldoms
kaliums1336603kali_ums
lidos65219883__lido_s
malisons1048783malisons
malodors1144973malodors
papadoms1575923papadoms
randoms102112433ra_ndoms
rhabdoms1643343rha_bdoms
selfdoms1443683selfdoms
shahdoms1743773sha_hdoms
shaloms1288983shal__oms
talions7314113tali_ons
talipots1045623talipots
thraldoms1542893thral_doms
thralldoms1651343thralldoms

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.403443402.0
2DLD Change Limit146162676.56322270.6
3Display Results67670.0332030.3
 (SQL Overall)178691676.99925530.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.