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

140 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
gobos8621938(None) 
gobo76126901gobo_
goboes95914441goboes
gobs76935571gob_s
gogos77516521gogos
gombos114311091gombos
goos57644911go_os
hobos106321351hobos
kobos115616891kobos
lobos75921841lobos
abos67734412_abos
adobos9438452adobos
ambos95321252ambos
bobs86340652bob_s
bohos105618252bohos
bolos75531372bolos
boobs96221992boobs
boos67955032bo_os
bos57966812__bos
boyos105418282boyos
bozos165216862bozos
cobbs115013992cobbs
cobs87043142cob_s
cocos95624692cocos
cohos105921852cohos
combos125316612combos
coos67456492co_os
dobros93910232dobros
dodos75819392dodos
dojos135111792dojos
fobs96034272fob_s
gabs76740422gab_s
gibes84422522gibes
gibs75529272gib_s
giros65722652giros
globes94314542globes
globose1035542globose
globous1036502globous
globs85616402glob_s
goads77022852goads
goals65521292goals
goas55239942go_as
goats65527302goats
gob68950892gob__
goban84414072goban
gobans94412042gobans
gobies95418062gobies
gobony1236912gobony
goby106021082gob_y
gods65438042go_ds
goers65520252goers
goes55644092go_es
gogo69722832gogo_
golds75421312golds
golfs95616102golfs
golosh1036462golosh
gombo105814042gombo_
gongs74921612gongs
gonof95218652gonof
gonofs10459862gonofs
goo47754772go_o_
good66531802go_od
goods75124482goods
goof85436872go_of
goofs94821002goofs
gook96429602go_ok
gooks105422882gooks
goon57236172go_on
goons65326772goons
goop75829482go_op
goops86620962goops
goose65925902go_ose
goosy96018882go_osy
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gos47155132g__os
goths96513002goths
gouts64826172gouts
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
goxes135018262goxes
goys86328412go_ys
gumbos114610872gumbos
gybes115012722gybes
gyros95616482gyros
hobo97026082hobo_
hoboes114717442hoboes
hobs97038982hob_s
homos105921782homos
jobs136529432job_s
kobo107422102kobo_
kobs105831082kob_s
kolos94921212kolos
kotos95717702kotos
lobes75331002lobes
lobo67229862lobo_
lobs66441082lob_s
locos75822602locos
logos67225332logos
loos49051122lo_os
lotos54724632lotos
mobs85737372mob_s
mojos145314462mojos
monos75930862monos
moos66051302mo_os
mozos165516332mozos
nobs66436902nob_s
nolos54423352nolos
nomos75919742nomos
obas65730932_obas
obes66036832_obes
obis66226842_obis
oboe66822942_oboe
oboes75717712_oboes
obol65220612_obol
obols73715862_obols
onos46229002_onos
poboy121612222poboy
poboys1397312poboys
polos76129912polos
pomos95321582pomos
poos65949112po_os
robes75133302robes
robot7325972robot
robots8313152robots
robs65837872rob_s
rotos56027882rotos
sobas74424252sobas
sobs64941752sob_s
solos54830792solos
topos75726392topos
toros54336192toros
toyos87519142toyos
umbos94613072umbos
woos76238802wo_os
yobbos1335962yobbos
yobs96028082yob_s
zoos135828802zo_os

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.310576422.6
2DLD Change Limit538001401.67332157.8
3Display Results1401400.0334242.4
 (SQL Overall)1786911402.01688636.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.