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

165 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
donators931040(None) 
donator8310261donator_
delators92314832delators
detonators1145852detonators
dilators93213202dilators
doctors1039992do_ctors
dominators1397482dominators
donates83217222donat_es
donations101112352donations
donors75115792don__ors
idolators1046282idolators
locators102910432locators
monitors10310822monitors
nonactors1147882nonactors
orators7313822_orators
pronators11411302pronators
rotators8310202rotators
senators8312952senators
abators94413093_abators
ablators1069883ablators
admonitors1342973admonitors
adulators1048063adulators
advocators1663913advocators
aerators8315613aerators
aviators11169903aviators
boaters93419243bo_aters
boniatos1046673boniato_s
bonitoes1038153bonitoes
bonitos939733bonito_s
cantors94620753can_tors
chantors133710263chantors
citators10310253citators
coactors1239483coactors
coaters93525793co_aters
coenamors1344703coenamors
cofactors1645943cofactors
collators11410343collators
conations111318903conations
conatus9310463conat_us
condors104018573con_dors
contactors1448843contactors
contort91422343con_tort
contorts101112643con_torts
contos84923233con_to_s
contours1039653con_tours
copastors1346993copastors
creators102814413creators
curators10311723curators
damnatory1544143damnatory
danazols1843083danazols
daters74827373d__aters
datos65222783d__ato_s
debaters113511923debaters
debtors1038533d_ebtors
decorators1347873decorators
deflators13348153deflators
delator83015033delator_
denars74621433dena__rs
denature938073denature
denatures1038133denatures
desolators1146283desolators
detonator1045983detonator_
deviators1358533deviators
dewaters122910723dewaters
diatoms1039073d_iatoms
dictators1247363dictators
dilaters92513063dilaters
dilator82712793dilator_
dilatory12279283dilatory
dilutors9306653dilutors
dinars75417563dina__rs
doats65224883do_at__s
doctor938993do_ctor_
dognapers1343073dognapers
dolors75115313do__lors
dominator1258233dominator_
donas65926473dona___s
donate73619503donat__e
donated93513863donat_ed
donating10311803donating
donation91513783donation
donative12139873donative
donatives13146903donatives
donjons1536733don_jons
donor64418193don__or_
donuts7410583donut__s
doors65022133do___ors
dorados938203dorado_s
dotations101411633dotations
doters74423913do__ters
dotters83715973do_tters
doubters11257393doubters
dowagers1334893dowagers
dynamos1373853dynamo_s
dynamotors1651383dynamotors
dynatron1243623dynatron
dynatrons1343393dynatrons
educators1246993educators
emanators1147033emanators
enactors1038463_enactors
enamors939123_enamors
equators1737473equators
evocators1446713evocators
foetors1039763fo_etors
functors1335743functors
gators74115843__gators
genitors937423genitors
grantors93810363grantors
gyrators1246003gyrators
honors94816793hon__ors
idolaters1045713idolaters
idolator946243idolator_
ignitors9135513ignitors
isolators947513isolators
janitors1536853janitors
legators92811033legators
levators11249283levators
locaters102710073locaters
locator93110423locator_
mandators1247873mandators
mentors9314993men_tors
minatory1338553minatory
monaxons1744813monaxons
monitor9310723monitor_
monitory1347853monitory
monsters103314553monsters
moratory1347823moratory
motors84616603mo__tors
negators92411173negators
nominators1277553nominators
nonactor1047783nonactor_
nonagons947223nonagons
nonauthors1352523nonauthors
nonfactors1545333nonfactors
nonmajors1843233nonmajors
nonstops10116883nonstops
nonstory1148103nonstory
oaters65029793_o_aters
odonates947743odonat_es
onagers838103_onagers
orator6314533_orator_
oratory1039403_oratory
pontons93315553pon_tons
potatoes1039943potatoes
potatory1348413potatory
pronator10311783pronator_
pronatores1247373pronatores
relators83316133relators
resonators1045813resonators
rogatory1246153rogatory
rotator7310833rotator_
rotatores946483rotatores
rotatory1147213rotatory
rotors64917953ro__tors
senator7313073senator_
sonars64818973sona__rs
sonatas7510293sonat_as
sonicators1277063sonicators
stators73915583_stators
tomatoes1038613tomatoes
urinators947633urinators
viators102712023_viators
violators1246583violators
wontons103310533won_tons
zonations18139313zonations

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 Limit1461621657.34619896.8
3Display Results1651650.0762171.1
 (SQL Overall)1786911657.82522835.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.