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 “holdall” 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
holdall114547(None) 
holdalls1244331holdalls
holdable1437072holdable
boldly12399423bold_ly
boxball18155323boxball
chordal13449883chorda_l
coldly12459953cold_ly
foldable1437133foldable
gildhall1342023gildhall
goldarn944383goldarn
hadal95518123h_ada_l
halal85623593hal_a_l
halala94715093hal_ala
halals95018313hal_als
hall75741163h___all
hallal94415563halla_l
handball1487033handball
hardball14116303hardball
heelball1343893heelball
hobnail1243973hobnail
hodad10311353ho_da_d
hodads1147963ho_dads
holard10410573hol_ard
hold86235063hold___
holdback2044513holdback
holden104113953hold_en
holder104619653hold_er
holders113715903holders
holdfast1553703holdfast
holding123514283holding
holdout11510903holdout
holds94623243hold__s
holdup1245183hold_up
holdups1333593holdups
holiday1436143holida_y
holidays1544103holidays
holily123612953hol_ily
holla84918493hol__la
hollaed11359853hollaed
holland11349473holland
hollas94616903holla_s
hollo84822163hol__lo
holly114824433hol__ly
holyday1743773holyda_y
holydays1843473holydays
honda9414983honda__
hondas10313353honda_s
hondle103914523hond_le
horal86328683ho_ra_l
houdah1335173houda_h
houdahs1434243houdahs
howdah1634723howda_h
howdahs1733613howdahs
hyoidal1444803hyoida_l
lall45531313__l_all
lowball1275503lowball
modal85919243mo_da_l
modally1338403mo_dally
modals93914463mo_dals
molal75120343mol_a_l
moldable1337103moldable
nodal64717793no_da_l
nodally1137913no_dally
oddball1143773_oddball
poolhall1343703poolhall
soldan73511853solda_n
soldans83210403soldans

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.423422437.4
2DLD Change Limit134027676.39020974.5
3Display Results67670.0135153.8
 (SQL Overall)178691676.82626178.0
 
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.