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

131 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
tonner6481920(None) 
conner84423961conner
tanner63722281tanner
tenner64117101tenner
tinner64119951tinner
toner55336241to_ner
tonger74719681tonger
tonier65520711tonier
tonne54921431tonne_
tonners73816401tonners
tonnes65320851tonnes
wonner95114441wonner
atoner64817192ato_ner
banner84421502banner
bonder95324782bonder
boner75133082bo_ner
bonier84321992bonier
bonne75124712bonne_
bonnes85621452bonnes
bonnet85524632bonnet
bonnier94711312bonnier
bonzer175313672bonzer
canner84625982canner
coiner84323782coiner
confer114018682confer
conger95024272conger
conker124721552conker
conned95119702conned
conners94023112conners
corner84625622corner
cunner83915002cunner
dinner74217152dinner
donne65520462donne_
donned85015742donned
donnee74317062donnee
donnerd9427812donnerd
donnert82815522donnert
downer104414922downer
dunner73913822dunner
fanner94218182fanner
fonder104120062fonder
funner93414102funner
ginner73915812ginner
goner66025152go_ner
gunner73813982gunner
honer85332092ho_ner
honker134117462honker
inner54920622_inner
joiner134114132joiner
lanner64920592lanner
loaner64416502loaner
loner55431032lo_ner
longer75823192longer
manner84020512manner
moaner84415112moaner
monger94418332monger
mooner85317832mooner
owner84613312_owner
panner84224762panner
penner84616662penner
pinner84521492pinner
ponder94521692ponder
punner84918152punner
ronnel63310882ronnel
runner63814462runner
sinner64320592sinner
sonder73623522sonder
sonnet65923502sonnet
sooner64220462sooner
sorner64720382sorner
stoner65823202sto_ner
stonier72013792stonier
stunner7349192stunner
tanker104521122tanker
tanned75219952tanned
tanners74018392tanners
tannery10388652tannery
teener64717502teener
tender74121842tender
tenners74014922tenners
tenoner739672tenoner
tenser64919432tenser
tenter64623932tenter
thinner10358962thinner
tinder73821802tinder
tinier63622232tinier
tinker103619922tinker
tinned74317532tinned
tinners73717302tinners
tinnier72910132tinnier
tinter63923642tinter
tocher114014912tocher
toiler63918282toiler
toker95924912to_ker
toller63819442toller
tone46953742to_ne_
toned65435342to_ned
toners64128002to_ners
tones56048662to_nes
toney86027412to_ney
tonged86518902tonged
tongers84116012tongers
tonlet62924702tonlet
tonneau765912tonneau
tooler63818612tooler
tooter64420802tooter
toper75231022to_per
topper103817602topper
tosser64215662tosser
toter55932132to_ter
tother94117142tother
totter65021462totter
tourer64115072tourer
touter63821032touter
tower85729202to_wer
townee92815212townee
toyer84521552to_yer
tuner56022682t_uner
tunned74014492tunned
tunnel64310632tunnel
turner63914612turner
twiner94012592twiner
vanner94215842vanner
wanner94019622wanner
winner94219922winner
wonder103617812wonder
wonned104012062wonned
wonners104312812wonners
yonder103214132yonder
yonker134110852yonker
zoner144520342zo_ner

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 Filter178691825510.1231452772.4
2DLD Change Limit825511313.31324917.3
3Display Results1311310.0761723.7
 (SQL Overall)1786911313.51250880.1
 
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.