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

108 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
placing12381528(None) 
lacing94626231_lacing
pacing114522751p_acing
peacing124117071peacing
planing103418251planing
plating103823071plating
playing133816091playing
acing87429152__acing
blacking174213602blacking
blading113615362blading
blaming123515692blaming
blaring104317112blaring
blawing134012752blawing
blazing193612392blazing
bracing123817612bracing
clacking173313492clacking
clawing133812672clawing
claying133614302claying
elating83423082elating
emplacing1645482emplacing
enlacing1148772enlacing
facing125321572_facing
flacking184311792flacking
flaking154114492flaking
flaming134216442flaming
flaring114116802flaring
flawing143812562flawing
flaying143914462flaying
glaceing1236532glaceing
glancing1247062glancing
glaring93714882glaring
glazing183611002glazing
gracing113216442gracing
inlacing1158372inlacing
lacings105013652_lacings
lacking143821542_lacking
lading84227122_lading
laking115027042_laking
laming94528362_laming
lancing103314122_lancing
lasing74727982_lasing
laving104623572_laving
lawing104625282_lawing
laying104525702_laying
lazing164821472_lazing
macing114221552_macing
packing164420722p_acking
paging104020402p_aging
paling93530132p_aling
palling104024492palling
palming123914012palming
palping124112872palping
paring94236492p_aring
paving124519742p_aving
pawing124519552p_awing
paying123722162p_aying
peaching163613642peaching
peaking144317692peaking
pealing104123202pealing
phasing133211672phasing
piecing12410452piecing
placating1438512placating
placid114012542placi_d
plaguing1236032plaguing
plain74823302pla_in_
plaining113911552plaining
plains85019592pla_ins
plaint85323202pla_int
plaiting113113512plaiting
planking153513012planking
planning113610222planning
planting113515382planting
plashing143311062plashing
platina94413642platina
platings113611362platings
platting114813032platting
pleaching17257082pleaching
pleading123011442pleading
pleasing112611592pleasing
pleating112916052pleating
plowing133111722plowing
ploying132811572ploying
plucking17357722plucking
pluming123412042pluming
plying124312082pl_ying
poaching163510832poaching
policing13311672policing
poncing122913582poncing
prancing132612162prancing
prating103424452prating
praying133717322praying
pricing123417342pricing
racing95030532_racing
relacing112516042relacing
replacing142210162replacing
slacking153914132slacking
slaking123717472slaking
slating83724652slating
slaving113514832slaving
slaying113316842slaying
slicing103514642slicing
solacing11310132solacing
spacing123614492spacing
splaying14219302splaying
splicing1338962splicing
talcing103111632talcing
tracing103720152tracing
unlacing1148652unlacing

Search took 6 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 Limit1076711085.01321478.4
3Display Results1081080.0502160.0
 (SQL Overall)1786911085.43932853.6
 
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.