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

76 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
donor6441819(None) 
dolor67617961dolor
donors75115791donors
door56928511do_or
honor85718621honor
boner75133082boner
boor66130682bo_or
color76123742color
condor94616972condor
decor84717572decor
denar65223292denar
dinar66319892dinar
diner65632902diner
dino56036752dino_
dinos65428062dinos
dobro84412212dobro
doctor938992doctor
dodo66024912dodo_
dodos75819392dodos
doer57734702do_er
dojo126016142dojo_
dojos135111792dojos
dolors75115312dolors
dolour75710132dolour
don46757652don__
dona55529632don_a
donas65926472donas
donator8310262donator
done55747912don_e
donee66931012donee
dong66031652don_g
donga76718422donga
dongs76525812dongs
donjon1436462donjon
donna66215032donna
donne65520462donne
dons56048702don_s
donsy96414682donsy
donut6324512donut
doom76430072do_om
doors65022132do_ors
doper86128392doper
dor47253922d__or
dorr56627722do_rr
doser66228562doser
doter65428622doter
dour56330432do_ur
dower95027702dower
downer104414922downer
dozer158419272dozer
droner74717672droner
goner66025162goner
gonof95218652gonof
honer85332092honer
honors94816792honors
honour94710862honour
kronor10417232kronor
loner55431042loner
manor78023932manor
minor74920062minor
mono66036722mono_
monos75930862monos
moor66628552mo_or
motor75317292motor
nor38048822__nor
odor55718092_odor
ono36838032_ono_
onos46229002_onos
poor65630222po_or
rotor55519732rotor
senor53822792senor
sonar56523422sonar
sopor74016492sopor
tenor53620252tenor
toner55336242toner
zoner144520342zoner

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800761.56334421.0
3Display Results76760.0135846.2
 (SQL Overall)178691761.88994595.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.