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

198 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
slating8372465(None) 
elating83423081elating
plating103823071plating
salting84120791salting
sating74735451s_ating
seating84130681seating
skating123613851skating
slaking123717471slaking
slanting94115091slanting
slatings94011721slatings
slatting94014231slatting
slaving113514831slaving
slaying113316841slaying
solating9315591solating
stating83725161stating
abating10413972abating
ablating11312002ablating
bating95132252_bating
beating104326872beating
blading113615362blading
blaming123515692blaming
blaring104317112blaring
blasting114013432blasting
blatting114111652blatting
blawing134012752blawing
blazing193612392blazing
bleating113514502bleating
bloating113512812bloating
boating103721302boating
clawing133812672clawing
claying133614302claying
cleating113518142cleating
coating103525312coating
crating103725202crating
dating85326482_dating
delating103119602delating
dilating102714912dilating
doating93816862doating
eating75134402_eating
eluting84115292eluting
estating92614992estating
fating105328672_fating
flaking154114492flaking
flaming134216442flaming
flaring114116802flaring
flatling123410012flatling
flatting123511252flatting
flawing143812562flawing
flaying143914462flaying
fliting113514612fliting
floating123111882floating
fluting113815092fluting
flyting14378552flyting
gating84826952_gating
gelating103015732gelating
glaring93714882glaring
glazing183611002glazing
gloating102611462gloating
grating93923182grating
halting114419072halting
hating104929712_hating
heating114024322heating
isolating1039742isolating
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
luting75221752_luting
malting103219082malting
mating94832912_mating
moating104218152moating
orating83520322orating
placing123815282placing
plaiting113113512plaiting
planing103418252planing
planting113515382planting
platina94413642platina
platings113611362platings
platting114813032platting
playing133816092playing
pleating112916052pleating
prating103424452prating
rating74938702_rating
relating92725442relating
reslating102516992reslating
saltine75018562saltine
saltings92811252saltings
saluting9310552saluting
salving113913152salving
saning75127642s_aning
satang75711562s_atang
satin55935222s_atin_
satins64930482s_atins
satiny93817982s_atiny
saving104724512s_aving
sawing104323812s_awing
saying104325542s_aying
scaling103519372scaling
scanting113914762scanting
scaping123715692scaping
scaring103421972scaring
scarting113415262scarting
scathing14269702scathing
scatting113311812scatting
sealing83528562sealing
seaming103222112seaming
searing83330922searing
seatings93614302seatings
sedating103014112sedating
setting83621392setting
shading123115562shading
shafting15278682shafting
shaking153317252shaking
shaming133016742shaming
shaping133116182shaping
sharing113723242sharing
shaving143414332shaving
shawing143514882shawing
shuting113212052shuting
sifting113014592sifting
silting83320482silting
siting74126622s_iting
sitting83519632sitting
skatings13326992skatings
skiting123812502skiting
slabbing13287782slabbing
slacking153914132slacking
slagging113711582slagging
slain54923572sla_in_
slamming133310002slamming
slang66324022sla__ng
slanging103413432slanging
slapping133510842slapping
slashing123713412slashing
slatier74016812slatier
slattings10346072slattings
sleaving123310982sleaving
sleeting93114162sleeting
slewing113311352slewing
slicing103514642slicing
sliding93114552sliding
sliming102913952sliming
sling66028802sl__ing
sliping103314412sliping
slitting93012582slitting
sloping104114072sloping
slotting92612612slotting
slowing112814742slowing
sluing74315882sl_uing
smarting113212452smarting
smiting103014442smiting
snaking123915302snaking
snaring83920952snaring
snawing113612482snawing
soaking123116612soaking
soaping103616222soaping
soaring83521892soaring
solacing11310132solacing
solvating1336442solvating
sooting82820962sooting
sorting83221812sorting
spacing123614492spacing
spading113114382spading
spaeing103413542spaeing
sparing104823872sparing
spatting113111762spatting
spaying133014622spaying
spiting103917622spiting
splatting1235982splatting
splaying14219302splaying
staging93818372staging
staking123919802staking
staling83925422staling
staning83922242staning
staring84527052staring
starting93116172starting
statin63921472statin_
statins73719772statins
staving113915702staving
staying114017322staying
sting65330242s__ting
sublating12310982sublating
suiting83419002suiting
sulfating1338062sulfating
swaging124210632swaging
swathing15248712swathing
swatting12309592swatting
swaying143610642swaying
sweating123213022sweating

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.360496363.9
2DLD Change Limit1076711983.04635348.3
3Display Results1981980.0633142.9
 (SQL Overall)1786911983.46951510.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.