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 “elating” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

161 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
elating8342308(None) 
delating103119601delating
eating75134401e_ating
eluting84115291eluting
gelating103015731gelating
plating103823071plating
relating92725441relating
slating83724651slating
abating10413972abating
ablating11312002ablating
aerating92821002aerating
bating95132252_bating
beating104326872beating
belaying143110602belaying
belting104119132bel_ting
berating113220762berating
blading113615362blading
blaming123515692blaming
blaring104317112blaring
blasting114013432blasting
blatting114111652blatting
blawing134012752blawing
blazing193612392blazing
bleating113514502bleating
bloating113512812bloating
boating103721302boating
chelating1549362chelating
clawing133812672clawing
claying133614302claying
cleating113518142cleating
coating103525312coating
crating103725202crating
dating85326482_dating
debating123213732debating
deflating142610712deflating
delaying133210972delaying
deleting103314422deleting
derating103222282derating
dilating102714912dilating
doating93816862doating
earing75235482e_aring
easing74926462e_asing
easting84924302easting
eatings84616442e_atings
editing9313132editing
elain55324702ela_in_
elains64919852ela_ins
elapine9310672elapine
elapsing1146712elapsing
elastin72611842elastin_
elastins82111742elastins
elation73620452elation
elations83719122elations
elative10312452elative
electing112113782electing
elevating1338202elevating
eliding93414342eliding
eloping103512832eloping
eluding93412112eluding
emoting10313562emoting
emulating1239872emulating
enacting11311362enacting
enlacing1148772enlacing
epilating12310972epilating
equating18310112equating
erasing8317962erasing
estating92614992estating
evading1237282evading
eviting11511372eviting
exacting1838522exacting
exalting1638032exalting
exiting15311392exiting
fating105328672_fating
fellating1339252fellating
felting113515212fel_ting
flaking154114492flaking
flaming134216442flaming
flaring114116802flaring
flatling123410012flatling
flatting123511252flatting
flawing143812562flawing
flaying143914462flaying
fliting113514612fliting
floating123111882floating
fluting113815092fluting
flyting14378552flyting
gating84826952_gating
gelatin83514732gelatin_
gelatine93213312gelatine
gelatins93414092gelatins
glaring93714882glaring
glazing183611002glazing
gloating102611462gloating
grating93923182grating
halting114419072halting
hating104929712_hating
heating114024322heating
lacing94626232_lacing
lading84227122_lading
laking115027042_laking
laming94528362_laming
lasing74727982_lasing
lasting84725242_lasting
lathing114315692_lathing
latina65621142_latina
latino64120472_latino
laving104623572_laving
lawing104625282_lawing
laying104525702_laying
lazing164821472_lazing
leading93419552leading
leafing113313582leafing
leaking123616972leaking
leaning83721202leaning
leaping103215992leaping
leasing83920162leasing
leaving114216852leaving
legating102313112legating
letting83218532letting
luting75221752_luting
malting103219082malting
mating94832912_mating
melting103317752mel_ting
moating104218152moating
negating102012832negating
orating83520322orating
pelting102917272pel_ting
placing123815282placing
plaiting113113512plaiting
planing103418252planing
planting113515382planting
platina94413642platina
platings113611362platings
platting114813032platting
playing133816092playing
pleating112916052pleating
prating103424452prating
rating74938702_rating
rebating112418342rebating
redating102620172redating
reflating132514712reflating
relacing112516042relacing
relaxing162612632relaxing
relaying122515152relaying
remating112322422remating
replating122217402replating
reslating102516992reslating
salting84120792salting
sating74735452_sating
seating84130682seating
sedating103014112sedating
skating123613852skating
slaking123717472slaking
slanting94115092slanting
slatings94011722slatings
slatting94014232slatting
slaving113514832slaving
slaying113316842slaying
solating9315592solating
stating83725162stating
welting113615312wel_ting

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711613.39031761.4
3Display Results1611610.0632555.6
 (SQL Overall)1786911613.82946667.8
 
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.