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

93 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
aleatory114883(None) 
aleatoric1145892aleatoric
amatory1238642a_matory
lavatory1445702lavatory
palpatory1645232palpatory
saltatory1245632saltatory
abator84512733a_bator_
abators94413103a_bators
abettor956203abettor_
abettors1056143abettors
ablator939863ablator_
ablators1069893ablators
additory1344263additory
adulatory1346313adulatory
aerator7314853aerator_
aerators8315623aerators
agentry11165753agent_ry
alary86123443al_a__ry
alastor739673alastor_
alastors8311223alastors
albacore1243553albacore
alerter72111513alerter_
alertly1046793alert_ly
alienator946203alienator_
alienators1045793alienators
allegory1244303allegory
amendatory1653123amendatory
anatomy1246233a_natomy
auditory1245703auditory
aviator10229683aviator_
aviators11169923aviators
aweary1237303awea__ry
bleary115112553blea__ry
bleater94515303bleater_
bleaters103412323bleaters
calefactory2152043calefactory
caveator1387233caveator_
caveators1497263caveators
citatory1347213citatory
clearstory1581923clearstory
creator93714453creator_
creators102814423creators
crematory1647223crematory
damnatory1544143damnatory
delator83015033delator_
delators92314833delators
dilatory12279283dilatory
eatery95316353__eatery
elector93313263elector_
electors103013863electors
elevator1146723elevator_
elevators1246313elevators
flavory1644743fl_avory
fleawort1447023fleawort
fumatory1644923fumatory
gyratory1544173gyratory
juratory1845183juratory
laudatory1344603laudatory
leary85927383_lea__ry
leathery14438973_leathery
lector83514993_lector_
lectors93415773_lectors
legator83011133_legator_
legators92811033_legators
levator10298973_levator_
levators11249293_levators
mandatory1545253mandatory
minatory1338553minatory
moratory1347823moratory
natatory1146613natatory
nugatory1245273nugatory
oblatory1345803oblatory
olfactory1743093olfactory
oratory1039403_oratory
palpator1247143palpator_
palpators1346813palpators
placatory1645723placatory
pleater93916333pleater_
pleaters103613793pleaters
potatory1348413potatory
precatory1649123precatory
predatory1547713predatory
prefatory1746693prefatory
pulsatory1474613pulsatory
rectory123512733_rectory
relator74016383relator_
relators83316143relators
rogatory1246153rogatory
rotatory1147213rotatory
salutatory1343553salutatory
sudatory1245843sudatory
valuator1196733valuator_
valuators1286473valuators

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.423422437.4
2DLD Change Limit146162936.72021750.3
3Display Results93930.0303100.0
 (SQL Overall)178691937.17324911.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.