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

133 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
planing10341825(None) 
placing123815281placing
plaining113911551plaining
planking153513011planking
planning113610221planning
planting113515381planting
plating103823071plating
playing133816091playing
alanin6317272alanin_
alanine7316862alanine
alanins7315802alanins
alining81917042alining
baning95127832_baning
beaning103820682beaning
blading113615362blading
blaming123515692blaming
blanking154411932blanking
blaring104317112blaring
blawing134012752blawing
blazing193612392blazing
caning94128622_caning
clanging124012122clanging
clanking154313062clanking
clawing133812672clawing
claying133614302claying
cleaning113112382cleaning
cloning103215472cloning
craning103620302craning
deaning94020472deaning
deplaning1338052deplaning
elating83423082elating
emplaning1446532emplaning
enplaning1246802enplaning
flaking154114492flaking
flaming134216442flaming
flanging132710582flanging
flanking164211082flanking
flaring114116802flaring
flawing143812562flawing
flaying143914462flaying
glancing1247062glancing
glaring93714882glaring
glazing183611002glazing
gleaning10269322gleaning
lacing94626232_lacing
lading84227122_lading
laking115027042_laking
laming94528362_laming
lancing103314122_lancing
landing92819322_landing
lasing74727982_lasing
laving104623572_laving
lawing104625282_lawing
laying104525702_laying
lazing164821472_lazing
leaning83721202leaning
lining74526802_lining
loaning83614832loaning
meaning103918702meaning
moaning103714442moaning
pacing114522752p_acing
paging104020402p_aging
paining103920242paining
paling93530132p_aling
palling104024492palling
palming123914012palming
palping124112872palping
panging113319112p_anging
panini8314272p_anini
panino8315682p_anino
panning104019392panning
panting104025422p_anting
paring94236492p_aring
paving124519742p_aving
pawing124519552p_awing
pawning134711412pawning
paying123722162p_aying
peacing124117072peacing
peaking144317692peaking
pealing104123202pealing
peening103318302peening
peining104619152peining
penning103616492penning
phasing133211672phasing
phoning13312052phoning
pining93726532p_ining
pinning103417852pinning
plaguing1236032plaguing
plain74823302pla_in_
plains85019592pla_ins
plaint85323202pla_int
plaiting113113512plaiting
planish12412062planish
plankings16326112plankings
plannings12325452plannings
plantings12348402plantings
plashing143311062plashing
platina94413642platina
platings113611362platings
platting114813032platting
pleading123011442pleading
pleasing112611592pleasing
pleating112916052pleating
plinking153611242plinking
plonking15358562plonking
plowing133111722plowing
ploying132811572ploying
pluming123412042pluming
plunging12357672plunging
plunking15328482plunking
plying124312082pl_ying
prancing132612162prancing
pranging123012722pranging
pranking153813382pranking
prating103424452prating
prawning1446962prawning
praying133717322praying
pruning10311732pruning
punning103414992punning
saning75127642_saning
slaking123717472slaking
slanging103413432slanging
slanting94115092slanting
slating83724652slating
slaving113514832slaving
slaying113316842slaying
speaning113512242speaning
splaying14219302splaying
splining11310772splining
staning83922242staning
waning103623802_waning
weaning114117192weaning
yeaning113814632yeaning

Search took 9 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 Filter1786911076711.046170832.7
2DLD Change Limit1076711336.84315734.5
3Display Results1331330.0931430.1
 (SQL Overall)1786911337.98222386.7
 
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.