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 “dilatory” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
dilatory1227928(None) 
dilator82712791dilator_
dilators93213201dilators
adulatory1346312adulatory
citatory1347212citatory
delator83015032delator_
delators92314832delators
depilatory1645742depilatory
dilater83515652dilater_
dilaters92513062dilaters
dilatorily1453282dilatorily
dilutor8256012dilutor_
dilutors9306652dilutors
minatory1338552minatory
oblatory1345802oblatory
ablator939853ablator_
ablators1069883ablators
adulator948593adulator_
adulators1048063adulators
aleatory1148823aleatory
amatory1238643_amatory
citator9310123citator_
citators10310253citators
damnatory1544143damnatory
datary10310243d__atary
dedicatory1745673dedicatory
deflator12328343deflator_
deflators13348153deflators
delusory1273003delusory
depilator1247653depilator_
depilators1347333depilators
deviatory1666453deviatory
diary95016973di_a__ry
diatom939453di_ato_m
diatoms1039073di_atoms
diatron839283di_atron
dictator1147263dictator_
dictators1247363dictators
dietary1158663di_etary
dilatably1544413dilatably
dilatancy1552523dilatancy
dilatant948203dilatant
dilatate947773dilatate
dilatator1044143dilatator_
dilatators1144013dilatators
dilate73220693dilat__e
dilated93115823dilat_ed
dilates83220663dilat_es
dilating102714913dilating
dilation92215463dilation
dilations102614453dilations
dilative1239523dilative
dilatometry1752443dilatometry
diluter8319663diluter_
diluters9288113diluters
directory1545883directory
distort81120333di_stort
divinatory1743943divinatory
donator8310263donator_
donators9310403donators
educatory1545443educatory
epilator1049243epilator_
epilators1149433epilators
filature1145433filature
flavory1644743_flavory
fumatory1644923fumatory
gyratory1544173gyratory
history1339423hi_story
idolator946243idolator_
idolators1046283idolators
idolatry1243263idolat_ry
indicatory1646383indicatory
judicatory2343693judicatory
juratory1845183juratory
lavatory1445703lavatory
libratory14255803libratory
mediatory1546433medi_atory
midstory1445103midstory
migratory1545343migratory
military1347233military
modulatory1644423modulatory
moratory1347823moratory
natatory1146613natatory
nugatory1245273nugatory
oratory1039403_oratory
ovulatory1544833ovulatory
palpatory1645233palpatory
pillory12247463pil_lory
piscatory1645273piscatory
potatory1348413potatory
pulsatory1474613pulsatory
relator74016373relator_
relators83316133relators
rogatory1246153rogatory
rotatory1147213rotatory
saltatory1245633saltatory
signatory1344623signatory
sudatory1245843sudatory
undulatory1444083undulatory
viator93211833vi_ator_
viators102712023vi_ators
vibratory17235563vibratory
victory15326983vi_ctory
violator1146283violator_
violators1246583violators

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.420425454.8
2DLD Change Limit1461621057.23620199.3
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.