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

159 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
donee6693101(None) 
done55747911don_e
donees74519491donees
donne65520461donne
donnee74317061donnee
bone65949322bon_e
boned85133242boned
boner75133082boner
bones76446532bones
boney105227312boney
bonne75124712bonne
bonze165119352bonze
cone67256962con_e
coned86040052coned
cones76457422cones
coney105932882coney
conge85227592conge
congee96024472congee
conte76633202conte
cooee74531022cooee
dance85223132dance
dee47665822d__ee
dene56643412den_e
denes65639722denes
dense65923502dense
diene65720132diene
dine55555342din_e
dined76431992dined
diner65632902diner
dines66449152dines
dinge75627302dinge
dobie84920332dobie
dodge86618132dodge
doe47361952do__e
doer57734702do_er
does56554472do_es
doge66233802do_ge
doges75630162doges
dogey105719512dogey
dogie75222792dogie
dolce85816682dolce
dole56550002do_le
doled75430912doled
doles67843752doles
dome77240732do_me
domed95423262domed
domes85735562domes
don46757652don__
dona55529632don_a
donas65926472donas
donate73619502donate
dong66031652don_g
donga76718422donga
dongle83612492dongle
dongs76525812dongs
donkey14449732donkey
donna66215032donna
donned85015742donned
donnees84210362donnees
donor64418192donor
dons56048702don_s
donsie7613642donsie
donsy96414682donsy
donut6324512donut
donzel1636312donzel
doolee73018952doolee
dope76038892do_pe
doped95326712doped
doper86128392doper
dopes84935042dopes
dopey116020352dopey
dore56353302do_re
dose56442432do_se
dosed76626912dosed
doser66228562doser
doses65938502doses
dote55442882do_te
doted75227072doted
doter65428622doter
dotes65836692dotes
douce85518422douce
douse66329722douse
dove85131562do_ve
doven94718552doven
doves94728152doves
dowed104632612dowed
dowel95618192dowel
dower95027702dower
dowie94721142dowie
downed115314782downed
downer104414922downer
dowse96020812dowse
doxie136017152doxie
doyen95014412doyen
doze145829082do_ze
dozed165619352dozed
dozen155017472dozen
dozer158419272dozer
dozes155226302dozes
dree56638322d_ree
drone65324982dron_e
droned84616862droned
droner74717672droner
drones75023432drones
dunce86319262dunce
dune56137582dun_e
dunes65332172dunes
dyne85320932dyn_e
dynel9569852dynel
dynes95917582dynes
gone55639042gon_e
gonef95221292gonef
goner66025162goner
hone77549322hon_e
honed95332262honed
honer85332092honer
hones88144492hones
honey115629912honey
jones125028182jones
knee85323612_knee
lone45849132lon_e
loner55431042loner
longe66626462longe
monde85723142monde
money104826842money
monie75631652monie
monte75829772monte
nee36657782__nee
nonce75719822nonce
none45743172non_e
nones55639132nones
nonet54540842nonet
ogee57629882_ogee
once65423082_once
one37050912_on_e
ones46146532_ones
ponce95222512ponce
pone65747532pon_e
pones74547042pones
pongee94920192pongee
ranee55438102ranee
sonde64622832sonde
sone46649982son_e
sones55444142sones
tone46953742ton_e
toned65435342toned
toneme8312102toneme
toner55336242toner
tones56048662tones
toney86027412toney
tonne54921432tonne
topee76029952topee
townee92815212townee
yogee9518062yogee
zonae145116442zonae
zone135231082zon_e
zoned154020262zoned
zoner144520342zoner
zones145528042zones

Search took 3 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 Limit538001592.00026900.0
3Display Results1591590.0305300.0
 (SQL Overall)1786911592.34376265.9
 
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.