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

184 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
dilators9321319(None) 
delators92314821delators
dilaters92513061dilaters
dilator82712781dilator_
dilatory12279271dilatory
dilutors9306651dilutors
ablators1069872ablators
adulators1048062adulators
citators10310252citators
deflators13348152deflators
delator83015022delator_
depilators1347332depilators
diatoms1039072di_atoms
dictators1247362dictators
dilatators1144012dilatators
dilater83515652dilater_
dilates83220662dilat_es
dilations102614452dilations
diluters9288112diluters
dilutor8256012dilutor_
donators9310402donators
epilators1149432epilators
idolators1046282idolators
relators83316122relators
viators102712022vi_ators
violators1246582violators
abators94413083_abators
abdicators1546263abdicators
ablator939843ablator_
adulator948593adulator_
adulatory1346313adulatory
aerators8315613aerators
agitators1046623agitators
alastors8311203_alastors
animators111210423animators
aviators11169903aviators
avigators13177093avigators
belabors1236403belabors
bilayers13296923bilayers
chelators1448163chelators
cilantros1142603cilantros
citator9310123citator_
citatory1347213citatory
clamors11710093_clamors
collators11410343collators
creators102814413creators
curators10311723curators
dalapons1145443dalapons
daltons8310403dal_tons
daters74827373d__aters
datos65222783d__ato_s
debaters113511923debaters
debtors1038533d_ebtors
decimators1547503decimators
dedicators1447743dedicators
deflaters13298703deflaters
deflator12328343deflator_
delates83526283delat_es
delations102616593delations
delayers12268663delayers
delegators1245633delegators
depilator1247653depilator_
depilatory1645743depilatory
desolators1146283desolators
deviators1358533deviators
dewaters122910723dewaters
dialers83614303di_alers
diallers957773diallers
dialogs938103di_alogs
diapers104713913di_apers
diapirs10347643di_apirs
diasters92913183diasters
diatom939453di_ato_m
diatron839283di_atron
diatrons939613di_atrons
dictator1147263dictator_
diesters92513603diesters
dieters83216433di_eters
digamous1296063digamous
digestors11257273digestors
dilatant948203dilatant
dilatants1044513dilatants
dilatate947773dilatate
dilatator1044143dilatator_
dilate73220693dilat__e
dilated93115823dilat_ed
dilating102714903dilating
dilation92215463dilation
dilative1239523dilative
dilatorily1453273dilatorily
dildoes9229243dil_does
dildos8179303dil_do_s
diluter8319663diluter_
dilutes82911973dilut_es
dilutions10248583dilutions
dimeters11411093dimeters
dinars75417563dina__rs
diopters1137693diopters
directors1248143directors
disasters1039153disasters
disavows1544043disavows
disfavors1643263disfavors
distort81120333di_stort
distorts91112353di_storts
dittos74111973di_tto_s
divisors12255693divisors
doctors1039993d_octors
dolors75115313dol__ors
dominators1397483dominators
donator8310263donator_
editors839423edi__tors
educators1246993educators
elaters74420193_elaters
emulators1148183emulators
epilator1049243epilator_
equators1737473equators
fellators1247143fellators
filature1145423filature
filatures1245853filatures
filters103816553fil_ters
flavors1337293_flavors
gators74115833__gators
gelatos83111513gelato_s
gigatons1046053gigatons
glamors1068113_glamors
gyrators1245993gyrators
hilltops1344933hilltops
idolaters1045713idolaters
idolator946243idolator_
imitators1147013imitators
indicators1348613indicators
inflators1257713inflators
isolators947513isolators
jilters144211963jil_ters
kilotons1286313kilotons
kilters113813603kil_ters
labors84016413__labors
legators92811033legators
levators11249283levators
lictors93212593li_ctors
locators102910433locators
mediators1248923medi_ators
meditators1346263meditators
migrators1247543migrators
milters93619093mil_ters
minatory1338553minatory
miradors1146853miradors
mislabors1344513mislabors
modulators1345333modulators
mutilators1266453mutilators
negators92411173negators
nitrators949213nitrators
oblatory1345793oblatory
orators7313823_orators
palpators1346793palpators
picadors1345853picadors
pilasters1138223pilasters
piscators1347083piscators
platers93924093_platers
pulsators1175373pulsators
radiators1049323radi_ators
realtors82811683realtors
relaters83218153relaters
relator74016363relator_
rialtos736613rialto_s
rotators8310203rotators
senators8312953senators
sibilators1245713sibilators
simulators1246103simulators
slaters73123733_slaters
stators73915583_stators
tilters73315953til_ters
titrators948383titrators
undulators1144833undulators
urinators947633urinators
valuators1286463valuators
viator93211833vi_ator_
viatores11257683vi_atores
vibrators14237253vibrators
victors123311183vi_ctors
violaters1245963violaters
violator1146283violator_
visitors1146433visitors
vitiators1246923vitiators

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 Limit1461621847.23620199.3
3Display Results1841840.0632920.6
 (SQL Overall)1786911847.71923149.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.