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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
fencing13241113(None) 
fencings14225661fencings
fending123717601fending
benching163411342benching
bending114420892bending
censing104215262censing
dancing113611562dancing
defencing16226692defencing
deicing11312192deicing
denning93515172denning
denting94422182denting
denying123711292denying
deucing1139392deucing
encina8310442_encina
ending83220252_ending
facing125321572f_acing
fancying1735352fancying
fanning113615072fanning
farcing133514002farcing
fearing113520032fearing
feasing113916652feasing
feazing205411442feazing
feeding123515072feeding
feeing104416502fe_eing
feeling113617072feeling
feezing204610162feezing
feinting123410832feinting
felling113321132felling
felting113515212felting
fessing113812862fessing
fetching17298412fetching
feting104417792fe_ting
fetting113517872fetting
feuding123410262feuding
feuing104412272fe_uing
finding124116542finding
fining104223212fin_ing
finking154016602finking
finning113615112finning
fleecing14347572fleecing
flenching18296702flenching
flensing1246972flensing
fonding123815422fonding
forcing134013752forcing
frenching18267752frenching
funding124113662funding
funking154013022funking
funning113813612funning
henting113719652henting
kenning124010542kenning
lancing103314122lancing
lending94118532lending
lensing84015102lensing
menacing1339782menacing
mending114018682mending
mensing103915102mensing
mincing123314332mincing
peacing124117072peacing
pending114119772pending
penning103616492penning
poncing122913582poncing
refencing15188852refencing
rending93924262rending
renting84026852renting
sending94221372sending
sensing84116952sensing
syncing13177222syncing
tending94419162tending
tensing84616652tensing
tenting84621152tenting
unfencing1545952unfencing
vending124015262vending
venging123710942venging
venting114218092venting
wenching17328862wenching
wending123816842wending
wincing133413902wincing
yenning11369492yenning
zincing192910282zincing

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.373479064.3
2DLD Change Limit107671793.36032044.9
3Display Results79790.0332393.9
 (SQL Overall)178691793.76647448.5
 
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.