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

162 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
ablators106988(None) 
abators94413091ab_ators
ablator939851ablator_
abaters95115202ab_aters
abator84512722ab_ator_
abettors1056132abettors
ablates92416902ablat_es
ablations11311512ablations
adulators1048062adulators
aerators8315612aerators
alastors8311222a_lastors
ambulators1445472ambulators
aviators11169902aviators
delators92314832delators
dilators93213202dilators
fabulators1544692fabulators
oblatory1345802oblatory
relators83316132relators
tabulators1245292tabulators
abasers95311973ab_asers
abater85518123ab_ater_
abates85825033ab_at_es
abatis84317933ab_at_is
abattis9297823ab_attis
abattoirs1142003abattoirs
abdicators1546263abdicators
abductors1443273abductors
abetters1057173abetters
abettor956193abettor_
abhors11410623ab__hors
ablate82219213ablat__e
ablated102513443ablat_ed
ablating11312003ablating
ablation10312433ablation
ablative1348243ablative
ablatives1445503ablatives
ablauts936083abla_uts
ablutions1146603ablutions
abnegators1343673abnegators
aborters1038573aborters
abraders1137343abraders
abrogators1345223abrogators
abutters1056993abutters
abwatts1233403abwat_ts
actors81016773a__ctors
actuators1146443actuators
adaptors1145263adaptors
adulator948593adulator_
adulatory1346313adulatory
aerator7314843aerator_
agitators1046623agitators
alamos8415003a_lamo_s
alastor739673a_lastor_
alates64833973a_lat_es
alations82518893a_lations
albacore1243543albacore
albacores1343323albacores
albatas938373albat_as
albatross1142573albatross
aleatory1148823aleatory
algors7312553a_l_gors
allantois985003allantois
allayers11156633allayers
alligators1145773alligators
allocators1246083allocators
altars64518153a_l_tars
alters64924223a_l_ters
altos55822953a_l_to_s
amatols938183a_matols
amatory1238643a_matory
ambulator1346163ambulator_
ambulatory1744403ambulatory
animators111210423animators
atlatls744773atlat_ls
auditors947613auditors
avatars1036443a_vatars
aviator10229663aviator_
avigators13177093avigators
balatas9311833balat_as
barrators1148393barrators
batons85519423_b_atons
beaters94925043_beaters
belabors1236403belabors
bettors93312473_bettors
bladers104214683_bladers
blamers115314213_blamers
blasters104116143_blasters
blathers134713793_blathers
blats75132503_blat__s
blatters104414093_blatters
blazers184811683_blazers
blazons1836163_blazons
bleaters103412323_bleaters
bloaters103311023_bloaters
boaters93419243_boaters
caveators1497263caveators
chelators1448163chelators
citators10310253citators
clamors11710093_clamors
collators11410343collators
creators102814413creators
curators10311723curators
deflators13348153deflators
delator83015033delator_
dilaters92513063dilaters
dilator82712793dilator_
dilatory12279283dilatory
dilutors9306653dilutors
donators9310403donators
elaters74420193_elaters
emulators1148183emulators
epilators1149433epilators
equators1737473equators
fabulator1445393fabulator_
fellators1247143fellators
flavors1337293_flavors
gators74115843__gators
gelatos83111523gelato_s
glamors1068123_glamors
gyrators1246003gyrators
idolators1046283idolators
inflators1257713inflators
isolators947513isolators
labors84016413__labors
labradors1243793labradors
laudators1045893laudators
legators92811033legators
levators11249283levators
locators102910433locators
mandators1247873mandators
narrators947863narrators
negators92411173negators
oblates91913243oblat_es
oblations1139373oblations
obligators13195443obligators
obligors1143523obligors
obviators1444843obviators
orators7313823_orators
palliators1245823palliators
palpators1346803palpators
platers93924093_platers
pulsators1175373pulsators
rabatos93010903rab_ato_s
radiators1049323radiators
realtors82811683realtors
relaters83218153relaters
relator74016373relator_
rotators8310203rotators
sabatons1037843sab_atons
senators8312953senators
sibilators1245713sibilators
slaters73123733_slaters
stators73915583_stators
tablature1143063tablature
tablatures1242783tablatures
tabletops1342943tabletops
tabulator1145923tabulator_
tubulators1244513tubulators
valuators1286473valuators
viators102712023_viators
vibrators14237253vibrators
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 Limit1461621627.06320694.0
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.54623680.2
 
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.