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

178 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
ablator93985(None) 
abator84512721ab_ator
ablators1069881ablators
abater85518122ab_ater
abators94413092ab_ators
abettor956192abettor
ablate82219212ablat_e
ablated102513442ablated
ablates92416902ablates
ablation10312432ablation
adulator948592adulator
aerator7314842aerator
alastor739672a_lastor
ambulator1346162ambulator
aviator10229662aviator
delator83015032delator
dilator82712792dilator
fabulator1445392fabulator
oblatory1345802oblatory
relator74016372relator
tabulator1145922tabulator
abaser86414343ab_aser
abate76627843ab_at_e
abated95918453ab_ated
abaters95115203ab_aters
abates85825033ab_ates
abatis84317933ab_atis
abattoir1042053abattoir
abdicator1446263abdicator
abductor1343563abductor
abetter958323abetter
abettors1056133abettors
abhor10411063ab__hor
ablating11312003ablating
ablations11311513ablations
ablative1348243ablative
ablaut8313263abla_ut
ablauts936083ablauts
ablaze17239833abla_ze
abler75624313abl__er
abloom1039783abl_oom
abluted10188363abluted
ablution1047223ablution
abnegator1243593abnegator
aborter939933aborter
abrader1038643abrader
abrogator1245363abrogator
abutter957513abutter
abwatt11410673abwat_t
abwatts1233403abwatts
actor71116083a__ctor
actuator1046643actuator
adaptor1034953adaptor
adulators1048063adulators
adulatory1346313adulatory
aerators8315613aerators
agitator946713agitator
alamo7418143a_lamo_
alamos8415003a_lamos
alar46340073a_la__r
alastors8311223a_lastors
alate55340333a_lat_e
alated75625153a_lated
alates64833973a_lates
alation72920553a_lation
albacore1243543albacore
albata839333albat_a
albatas938373albatas
aleatory1148823aleatory
algor6513053a_l_gor
allayer10148213allayer
alligator1046113alligator
allocator1145783allocator
altar55520643a_l_tar
alter54828503a_l_ter
alto47831263a_l_to_
altos55822953a_l_tos
amatol838693a_matol
amatory1238643a_matory
ambulators1445473ambulators
ambulatory1744403ambulatory
animator101410293animator
atlatl637873atlat_l
atlatls744773atlatls
auditor837313auditor
avatar937523a_vatar
aviators11169903aviators
avigator12236773avigator
balata8614683balat_a
balatas9311833balatas
barrator1048403barrator
baton75822423_b_aton
beater84729393_beater
belabor1136293belabor
bettor83612223_bettor
blader93618583_blader
blamer104417143_blamer
blaster94017303_blaster
blat66550953_blat__
blate75933783_blat_e
blather125314213_blather
blats75132503_blat_s
blatter94415653_blatter
blazer174414023_blazer
blazon1736763_blazon
bleater94515303_bleater
bloater94013423_bloater
boater84622093_boater
caveator1387233caveator
chelator1347913chelator
citator9310123citator
clamor1049453_clamor
collator10310373collator
creator93714443creator
curator9312213curator
deflator12328343deflator
delators92314833delators
dilater83515653dilater
dilators93213203dilators
dilatory12279283dilatory
dilutor8256013dilutor
donator8310263donator
elater64724203_elater
emulator1048743emulator
epilator1049243epilator
equator1637483equator
fabulators1544693fabulators
fellator1176713fellator
flavor1236663_flavor
gator64416043__gator
gelato73812963gelato_
gelatos83111523gelatos
glamor958193_glamor
gyrator1135723gyrator
idolator946243idolator
inflator1158033inflator
isolator847533isolator
labor75117313__labor
labrador1143883labrador
later54843923__later
laudator945883laudator
legator83011133legator
levator10298963levator
locator93110423locator
mandator1148183mandator
narrator847563narrator
negator83010673negator
oblate82214743oblat_e
oblates91913243oblates
oblation1039863oblation
obligator12195693obligator
obligor1043533obligor
obviator1344743obviator
orator6314533_orator
palliator1146003palliator
palpator1247133palpator
plater84427693_plater
pulsator1085693pulsator
rabato83413263rab_ato_
rabatos93010903rab_atos
radiator949203radiator
realtor73611353realtor
relater73723143relater
relators83316133relators
rotator7310833rotator
sabaton937713sab_aton
senator7313073senator
sibilator1145703sibilator
slater64429183_slater
stator64015483_stator
tablature1143063tablature
tabletop1243413tabletop
tabulators1245293tabulators
tubulator1145033tubulator
valuator1196733valuator
viator93211833_viator
vibrator13227343vibrator
violator1146283violator

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271787.31318327.2
3Display Results1781780.0632825.4
 (SQL Overall)1786911787.78222962.1
 
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.