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

140 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
placating143851(None) 
glaciating1445602glaciating
lactating1239192_lactating
locating11311502_locating
palpating1438542palpating
placarding1643412placarding
placatingly1952332placatingly
placation1339772placation
placations1438582placations
placative1646222placative
placing123815282plac__ing
plaiting113113512pla_iting
planting113515382pla_nting
plating103823072pl__ating
platting114813032pla_tting
playacting1842702playacting
pleating112916052pl_eating
vacating14310362_vacating
abating10413973__abating
acting95920983__ac_ting
allocating1347383allocating
blacking174213603blac_king
blasting114013433bla_sting
blatting114111653bla_tting
bleating113514503bl_eating
bloating113512813bl_oating
clacking173313493clac_king
cleating113518143cl_eating
coacting133412703coac_ting
colocating1548623colocating
duplicating1745403duplicating
educating1337933educating
elating83423083el__ating
electing112113783elec_ting
elevating1338203elevating
eliciting1237773eliciting
emaciating1546823emaciating
emanating1239003emanating
enacting11311363enac_ting
evacuating1645683evacuating
exacting1838523exac_ting
explicating2356123explicating
faceting1438783_faceting
flacking184311793flac_king
flatting123511253fla_tting
flaunting1335043flaunting
floating123111883fl_oating
furcating1537783furcating
glaceing1236533glac_eing
gloating102611463gl_oating
gradating1237323gradating
implicating1855743implicating
lacerating1349453_lacerating
lacewing1435843_lacewing
lacing94626233_lac__ing
lacking143821543_lac_king
lariating10311793_lariating
lasting84725243_la_sting
legating102313113_legating
lichting14268513_lichting
ligating102212283_ligating
luxating1645613_luxating
oxalating1745803oxalating
pacing114522753p_ac__ing
packaging1945163p_ackaging
packeting1836853p_acketing
packing164420723p_ac_king
painting113614423p_ainting
palatine10316073p_alatine
palleting1238743palleting
palliating1347893palliating
pancaking1836383pancaking
panting104025423p_a_nting
parading12313863p_arading
parawing14310583p_arawing
parting103527383p_a_rting
pasting103826553p_a_sting
patting103722343p_a_tting
peaching163613643peac_hing
peacing124117073peac__ing
phonating1537813phonating
picoting1338883p_icoting
pirating11314513p_irating
placate11312433placat__e
placated1338453placat_ed
placater1238013placat_er
placaters1336473placaters
placates12311753placat_es
placatory1645723placatory
plaguing1236033pla_guing
plaining113911553pla_ining
plaitings12296243pla_itings
planation11310123planation
planations1238723planations
planing103418253pl__aning
planking153513013pla_nking
planning113610223pla_nning
plantain1047903plantain_
plantains1147493plantains
plantings12348403pla_ntings
plashing143311063pla_shing
plateauing1343313plateauing
platina94413643pl__atina
platings113611363pl__atings
playactings1951353playactings
playgoing1663563playgoing
playing133816093pl__aying
playmaking2243393playmaking
plaything1843853plaything
pleaching17257083pleac_hing
pleading123011443pl_eading
pleasing112611593pl_easing
plication13311683plication
plications14310493plications
plighting1635563plighting
plotting113011013pl_otting
plucking17357723pluc_king
poaching163510833poac_hing
prating103424453p__rating
preacting142412533preac_ting
precasting15169833precasting
predating13514653predating
prelocating1647413prelocating
probating14311193probating
pronating12313763pronating
prorating12314283prorating
pulsating1236343pulsating
pupating1337683p_upating
reacting113317893reac_ting
relocating13310873relocating
replicating1649093replicating
slacking153914133slac_king
slanting94115093sla_nting
slating83724653sl__ating
slatting94014233sla_tting
splatting1235983spla_tting
ululating1036643ululating
unabating1246753unabating
valuating1338653valuating
yachting1734933_yachting

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411407.03021143.8
3Display Results1401400.0801750.0
 (SQL Overall)1786911407.51623774.7
 
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.