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

192 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
goby10602108(None) 
doby106022161doby
gaby107123191gaby
gob68950891gob_
gobo76126901gobo
gobs76935571gobs
gory86129661gory
goy77844551go_y
toby96322291toby
aby810238062_aby
agony96415652agony
baby116723682baby
bob76755672bob_
bobby114814662bobby
bobs86340652bobs
body107425672body
bogy106426192bogy
bony96732082bony
booby125319512booby
boxy166420732boxy
boy87753562bo_y
by77529232__by
cob710258752cob_
cobb106422002cobb
cobby145516412cobby
cobs87043142cobs
coky137526822coky
colby124415062colby
coly96940532coly
cony96537832cony
copy116229802copy
corby125018532corby
cory96941512cory
cosy97232702cosy
cowy126427362cowy
coy810557552co_y
cozy185823802cozy
dobby136013632dobby
dogy96126492dogy
dopy106224152dopy
dory85836232dory
doty86128222doty
doxy156419952doxy
dozy175920322dozy
fob86748332fob_
fobs96034272fobs
fogy115923182fogy
forby135317672forby
foxy176517752foxy
foy96044262fo_y
fozy197017162fozy
gab67155992gab_
gabby135512952gabby
gabs76740422gabs
gamy105427532gamy
gapy106320912gapy
gay76856492g_ay
gey75738302g_ey
gib66443532gib_
gibe75927782gibe
gibs75529272gibs
gley85724652gley
glob76623392glob_
globby1434682globby
globe84917012globe
globs85616402globs
glory96413292glory
go38748742go__
goa47343802go_a
goad66830982goad
goal55829302goal
goas55239942goas
goat56250832goat
goban84414072goban
gobony1236912gobony
gobos86219382gobos
god57449792go_d
godly104913292godly
gods65438042gods
goer56827102goer
goes55644092goes
gogo69722832gogo
gold65430162gold
golf85731182golf
golly95121102golly
gombo105814042gombo
gone55639042gone
gong66827192gong
goo47754772go_o
good66531802good
goodby13406282goodby
goody105620392goody
gooey95522862gooey
goof85436872goof
goofy124915622goofy
gook96429602gook
gooky135818032gooky
goon57236172goon
goony95519782goony
goop75829482goop
goopy115816622goopy
goos57644912goos
goosy96018882goosy
gor47848262go_r
gore55744962gore
gorm75529392gorm
gorp75625902gorp
gorsy95915782gorsy
gos47155132go_s
gosh86123422gosh
got49870442go_t
goth86825082goth
gout56646002gout
gouty95217362gouty
gowd96519982gowd
gowk125516472gowk
gown85724072gown
gox117137182go_x
goys86328412goys
gray85329892gray
grey85624042grey
grody103412062grody
guy75728942g_uy
gybe105916242gybe
hob87550922hob_
hobby155913732hobby
hobo97026082hobo
hobs97038982hobs
holy106333432holy
homy126623222homy
hoy97447912ho_y
inby95315662inby
job128041772job_
jobs136529432jobs
joey145719332joey
joky186215312joky
joy137036362jo_y
kob99442382kob_
kobo107422102kobo
kobs105831082kobs
lob57154462lob_
lobby125113922lobby
lobe65535362lobe
lobo67229862lobo
lobs66441082lobs
logy87025782logy
looby108115622looby
lory75931712lory
mob78651922mob_
mobs85737372mobs
moly96031912moly
mony96830012mony
mopy115721972mopy
nob58954422nob_
nobby125513462nobby
nobly105314402nobly
nobs66436902nobs
nosy76322892nosy
oba57531552_oba
obe56638642_obe
obey96521302_obey
obi57127732_obi
oozy167018132oozy
orby97519602orby
oxy136320982_oxy
oy58950132_o_y
poboy121612222poboy
pogy105623552pogy
poky135922152poky
poly96235152poly
pony96434052pony
posy96028422posy
poxy166820892poxy
rob56754302rob_
robe65335642robe
robs65837872robs
ropy96323412ropy
rosy76024872rosy
ruby97819942ruby
sob57857942sob_
soba64927922soba
sobs64941752sobs
soy67851452so_y
tody86327212tody
tony75635152tony
tory75840542tory
towy105325472towy
toy69655192to_y
upby1139062upby
womby155910092womby
yob87945272yob_
yobs96028082yobs

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 Filter178691298720.266671770.7
2DLD Change Limit298721920.84335435.3
3Display Results1921920.0464173.9
 (SQL Overall)1786911921.155154710.8
 
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.