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 “bonne” 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
bonne7512471(None) 
benne76521121benne
bone65949321bo_ne
bonnes85621451bonnes
bonnet85524631bonnet
bonnie85314851bonnie
bonny105816621bonny
bonze165119351bonze
borne77926791borne
donne65520461donne
tonne54921431tonne
bane65250432b_ane
banned94721342banned
banner84421502banner
bannet84925332bannet
banns75321232banns
baronne938272baronne
bene66439492b_ene
bennes86019012bennes
bennet84823362bennet
benni74715362benni
benny105217362benny
bine66650862b_ine
binge85125512binge
binned94414542binned
blonde94813292blonde
bocce114313112bocce
boche124216952boche
bode75838752bo_de
bogie89524102bogie
bogle85821682bogle
boing84725552boing
boink115516332boink
boite74426322boite
bole66448692bo_le
bombe115519312bombe
bond75334362bo_nd
bonded104719952bonded
bonder95324782bonder
bonds86126842bonds
boned85133242boned
boner75133082boner
bones76446532bones
boney105227312boney
bong75633412bo_ng
bonged105719602bonged
bongo85720942bongo
bongs87828422bongs
bonier84321992bonier
boning94223292boning
bonk105531712bo_nk
bonked135517312bonked
bonks116326462bonks
bonnets94812802bonnets
bonnier94711312bonnier
bonus75324322bonus
bony96732082bo_ny
bonzer175313672bonzer
bonzes175116102bonzes
boon67142172boon_
boons75031912boons
booze164718912booze
borane84620212borane
bore66051332bo_re
born67338412born_
boule74828042boule
bounce104014832bounce
bound84819582bound
bourne83714092bourne
bouse75931852bouse
bovine11712432bovine
bowse105420632bowse
brine75132272brine
bronze173610922bronze
bunn65023652bunn_
bunns74718292bunns
bunny104715802bunny
cone67256962co_ne
conge85227592conge
conine84528552conine
conn66229132conn_
conned95119702conned
conner84423962conner
conns75024232conns
conte76633202conte
done55747912do_ne
donee66931012donee
donna66215032donna
donned85015742donned
donnee74317062donnee
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
ronnel63310892ronnel
sonde64622832sonde
sone46649982so_ne
sonnet65923502sonnet
sonny85016102sonny
tone46953742to_ne
tonner64819202tonner
tonnes65320852tonnes
wonned104012062wonned
wonner95114442wonner
zonae145116442zonae
zone135231082zo_ne

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 Limit538001191.64032804.9
3Display Results1191190.0303966.7
 (SQL Overall)1786911191.98390111.4
 
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.