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

94 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
bonze16511935(None) 
bone65949321bon_e
bonne75124711bonne
bonzer175313671bonzer
bonzes175116101bonzes
booze164718911booze
bronze173610921bronze
baize164717392baize
bane65250422ban_e
bene66439492ben_e
benne76521122benne
bine66650852bin_e
binge85125512binge
bize155926282b_ize
blaze165520832blaze
blonde94813292blonde
bocce114313112bocce
boche124216952boche
bode75838752bo_de
bogie89524102bogie
bogle85821682bogle
boite74426322boite
bole66448692bo_le
bombe115519312bombe
bond75334362bon_d
bonded104719952bonded
bonder95324782bonder
bonds86126842bonds
boned85133242boned
boner75133082boner
bones76446532bones
boney105227312boney
bong75633412bon_g
bonged105719602bonged
bongo85720942bongo
bongs87828422bongs
bonier84321992bonier
bonk105531712bon_k
bonked135517312bonked
bonks116326462bonks
bonnes85621452bonnes
bonnet85524632bonnet
bonnie85314852bonnie
bonny105816622bonny
bonus75324322bonus
bony96732082bon_y
boozed184813832boozed
boozer174815962boozer
boozes174916522boozes
boozy194917062boozy
bore66051332bo_re
borne77926792borne
boule74828042boule
bounce104014832bounce
bouse75931852bouse
bowse105420632bowse
bozo156821412bo_zo
braze165423452braze
bronzed19308212bronzed
bronzer18348492bronzer
bronzes183510402bronzes
bronzy20306712bronzy
cone67256962con_e
conge85227592conge
conte76633202conte
done55747912don_e
donee66931012donee
donne65520462donne
donzel1636312donzel
doze145829082do_ze
ebonize1838152ebonize
gone55639042gon_e
gonzo15310242gonzo
hone77549322hon_e
ionize154613862ionize
lone45849132lon_e
longe66626462longe
monde85723142monde
monie75631652monie
monte75829772monte
nonce75719822nonce
none45743172non_e
once65423082_once
one37050912_on_e
ooze136420602_ooze
ponce95222512ponce
pone65747532pon_e
sonde64622832sonde
sone46649982son_e
tone46953742ton_e
tonne54921432tonne
winze175014852winze
zonae145116442zonae
zone135231082zon_e

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 Limit53800941.64032804.9
3Display Results94940.0332848.5
 (SQL Overall)178691941.766101184.0
 
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.