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 “gobonee” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
gobonee107778(None) 
botonee9311832botonee
goboes95914442gobo_es
gobony1236912gobon_y
gooney106612312go_oney
goonie73615562go_onie
ambones11312683ambones
boloney1247763boloney
bone65949323__bon_e
boned85133243__boned
boner75133083__boner
bones76446533__bones
boney105227313__boney
bonne75124713__bonne
bonze165119353__bonze
bootee84323023bo_otee
botonnee1044693botonnee
cojones163512103cojones
colone85425003colon_e
colonel94213283colonel
colones96124433colones
cooee74531023co_o_ee
coronae94214893coronae
coronel94515223coronel
coroner94218203coroner
coronet94227173coronet
debone93714783debon_e
deboned113411633deboned
deboner103110483deboner
debones103315113debones
doblones1136763doblones
donee66931013__donee
donnee74317063do_nnee
doolee73018953do_olee
globose1035543globo_se
goatee73219533go_atee
goban84414073goban__
gobang10376703goban_g
gobangs11385833gobangs
gobans94412043goban_s
gobbed124613883gob_bed
gobbet114214443gob_bet
gobble113512983gob_ble
gobbled134010253gobbled
gobbler123310023gobbler
gobbles123512583gobbles
gobies95418063gob_ies
goblet93219483gob_let
gobo76126903gobo___
gobos86219383gobo__s
goloshe1134733goloshe
gone55639043g__on_e
gonef95221293g__onef
goner66025163g__oner
goober93911743go_ober
goodie83613993go_odie
gooey95522863go_o_ey
goofed114911383go_ofed
gooier73516213go_oier
goon57236173go_on__
gooneys11407073go_oneys
goonier83612843go_onier
goonies83618333go_onies
goons65326773go_on_s
goony95519783go_on_y
goose65925903go_o_se
goosed86817033go_osed
gooses75723053go_oses
goosey105913513go_osey
gowaned1235763gowaned
gowned114410133go_wned
hoboed124511683hobo_ed
hoboes114717443hobo_es
honoree10412113honoree
ionone6313443ionon_e
ionones7313883ionones
kokanee1044803kokanee
looney94712413lo_oney
loonie64216453lo_onie
mooned94216643mo_oned
mooner85317833mo_oner
mooneye12116933mo_oneye
nominee9311583nominee
oboe66822943_obo__e
oboes75717713_obo_es
obole75917143_obo_le
oboles83815833_oboles
ozone14310613_ozon_e
ozones1539393_ozones
soignee8279133soignee
sooner64220463so_oner
toonie63617993to_onie
townee92815213to_wnee
umbones1138013umbones
unboned103014223unboned
zooned164011083zo_oned

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit134027966.94019312.2
3Display Results96960.0303200.0
 (SQL Overall)178691967.36024278.7
 
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.