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

119 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
donne6552046(None) 
bonne75124711bonne
done55747911do_ne
donee66931011donee
donna66215031donna
donned85015741donned
donnee74317061donnee
tonne54921431tonne
benne76521122benne
bone65949322bo_ne
bonnes85621452bonnes
bonnet85524632bonnet
bonnie85314852bonnie
bonny105816622bonny
bonze165119352bonze
borne77926792borne
cone67256962co_ne
conge85227592conge
conine84528552conine
conn66229132conn_
conned95119702conned
conner84423962conner
conns75024232conns
conte76633202conte
dance85223132dance
dene56643412d_ene
denned84215632denned
dense65923502dense
diene65720132diene
dine55555332d_ine
dinge75627302dinge
dinned84317612dinned
dinner74217162dinner
dobie84920332dobie
dodge86618122dodge
doe47361952do__e
doge66233802do_ge
dogie75222792dogie
doing74923582doing
dolce85816682dolce
dole56550002do_le
dome77240732do_me
domine92918252domine
don46757652do_n_
dona55529632do_na
donas65926472donas
donate73619502donate
donees74519492donees
dong66031652do_ng
donga76718422donga
dongle83612492dongle
dongs76525812dongs
donkey14449732donkey
donnas75511322donnas
donnees84210362donnees
donnerd9427812donnerd
donnert82815522donnert
donor64418192donor
dons56048702do_ns
donsie7613642donsie
donsy96414682donsy
donut6324512donut
donzel1636312donzel
dope76038892do_pe
dore56353302do_re
dose56442432do_se
dote55442882do_te
douce85518422douce
douse66329722douse
dove85131562do_ve
doven94718552doven
dowie94721142dowie
down86427492down_
downed115314782downed
downer104414922downer
downs94918572downs
downy125714552downy
dowse96020812dowse
doxie136017152doxie
doyen95014412doyen
doyenne1143882doyenne
doze145829082do_ze
dozen155017472dozen
drone65324982drone
dunce86319262dunce
dune56137582d_une
dunned85015522dunned
dunner73913822dunner
dwine95616142dwine
dyne85320932d_yne
gone55639042go_ne
hone77549322ho_ne
ionone6313442ionone
koine9516482koine
lone45849132lo_ne
longe66626462longe
monde85723142monde
monie75631652monie
monte75829772monte
nonce75719822nonce
none45743172no_ne
once65423082_once
one37050912_o_ne
panne76623652panne
penne75423852penne
ponce95222512ponce
pone65747532po_ne
ronnel63310882ronnel
sonde64622832sonde
sone46649982so_ne
sonnet65923502sonnet
sonny85016102sonny
tone46953742to_ne
tonner64819202tonner
tonnes65320852tonnes
wonned104012062wonned
wonner95114442wonner
zonae145116442zonae
zone135231082zo_ne

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.0931921408.6
2DLD Change Limit538001191.65632487.9
3Display Results1191190.0333606.1
 (SQL Overall)1786911191.782100275.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.