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

64 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
challoth1631610(None) 
challot123613261challot_
chaloth15298601cha_loth
halloth134111251_halloth
challah15458322chall_ah
chalot113020132cha_lot_
hallot95426782_hallot_
shallot103614132shallot_
shallots11319502shallots
agalloch1442133agalloch
allot54933873__allot_
allots64019173__allots
ballot84624093_ballot_
ballots94116033_ballots
callet84536763c_allet_
callets93821703c_allets
callose9313663c_allose
callous93516603c_allous
callow114714663c_allo_w
chalah143511663cha_l_ah
chaleh143711993cha_l_eh
chalet113825993cha_let_
chalets122813473cha_lets
challa114014193chall__a
challahs16377563challahs
challas124414123chall_as
challie124012853chall_ie
challies133915643challies
challis124613463chall_is
chally144314293chall__y
chalone12312103cha_lone
chalutz2195093cha_lutz
chaplet14512253chaplet_
chaplets1556883chaplets
chariot12316213chariot_
chariots1339393chariots
charlock1944393charlock
charlotte1443793charlotte
chayote1536493cha_yote
cloth105817543c___loth
halakoth1873443_halakoth
hallah124115403_hall_ah
hallo85127553_hallo__
halloa94918123_hallo_a
halloas104318463_halloas
halloed113314913_halloed
halloes104021523_halloes
halloo95118973_hallo_o
halloos103716743_halloos
hallos95425103_hallo_s
hallow124818323_hallo_w
hallows134417393_hallows
harlot94422803_harlot_
harlots103413293_harlots
reallot7312133reallot_
reallots837993reallots
shalloon1145683shalloon
shallop12348453shallo_p
shallops13288323shallops
shallow13388873shallo_w
shallows14388863shallows
tallith102913063_tallith
thalloid1246283thalloid
thallous1136523thallous

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 Filter1786911461620.406440125.6
2DLD Change Limit146162646.39022873.6
3Display Results64640.0331939.4
 (SQL Overall)178691646.82926166.5
 
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.