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

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

89 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
dehorners134474(None) 
dehorner1235521dehorner_
deboners11268112debo_ners
deforcers15265502deforcers
deformers15266532deformers
dehorned1345682dehorne_d
dehorns11428362dehorn__s
deporters1277792deporters
dethroners1443632dethroners
dewormers15255192dewormers
abhorrers1442983abhorrers
adorners9196623_adorners
beholders1544933beholders
churners13316893_churners
corners94723313__corners
darners83815773d__arners
deadeners1146283deadeners
dearness939973de_arness
debarkers16164553debarkers
deboner103110483debo_ner_
debones103315113debo_ne_s
decliners12358613decliners
decoders122810413deco_ders
decoyers14287713deco_yers
decreers11277623de_creers
decriers11299733de_criers
deepeners1244523deepeners
deferrers13115153deferrers
definers124211193de_finers
defoamers15285253defoamers
defoggers1543053defoggers
deforcer14246903deforcer_
deforces14248403deforce_s
deformer14247943deformer_
dehorn10439653dehorn___
dehorning1455243dehorning
dehorted1357303dehorte_d
dehorts11379773dehor__ts
dejeuners1742443dejeuners
delousers1044663delousers
demergers13146403demergers
demoness1138053demo_ness
demurrers1243713demurrers
denouncers1343403denouncers
deplorers1245463deplor_ers
depones103717093depo_ne_s
deportees1256643deportees
deporter1169393deporter_
deposers11359243depo_sers
descriers1245693descriers
deserters10129983deserters
deservers13107293deservers
designers1136003designers
desirers939263desir_ers
destriers1038143destriers
detainers10269103detainers
detergers11147183detergers
deterrers10116593deterrers
dethroner1344483dethroner_
dethrones1347313dethrone_s
devourers1344093devourers
dewormer14256323dewormer_
disorders1146963disorders
divorcers1543693divorcers
dormers104313923d__ormers
dorpers104113173d__orpers
dorsers83516303d__orsers
downers113912773d__owners
droners84114383d_ro_ners
drowners12428273d_rowners
earners74016453_e_arners
eloiners8128153_eloiners
exhorters1944713exhorters
honers94324973__ho_ners
hornets104113553__hornets
learners8398153le_arners
recorders12187953recorders
reformers14246403reformers
reorders9198833re_orders
reporters1139173reporters
resorters939693resorters
retorters938773retorters
returners9376553returners
schooners1445663schooners
scorners10228493_scorners
sorners73416873__sorners
suborners1146313suborners
tenoners858713teno_ners
yearners11346373ye_arners

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.1701051123.5
2DLD Change Limit148641896.84621712.1
3Display Results89890.0302966.7
 (SQL Overall)178691897.04625360.6
 
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.