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

201 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
gaol5692541(None) 
gal46055511ga_l
gall56335991gall
gaols66717571gaols
goal55829301goal
aal39058672_aal
ago48845522ago_
agog68019002agog
agon56531882agon
ail37171042_ail
al210674042_a_l
all36148232_all
awl67635302_awl
awol75620672awol
baal67033112baal
bail65042802bail
bal56662722ba_l
ball66043322ball
bawl95326062bawl
call66838672call
calo64936442calo
carl65144782carl
carol75128612carol
caul65630002caul
coal66939252coal
col59360352_col
cool66940492cool
dahl87019222dahl
dal47554952da_l
diol57329132diol
dol47150652_dol
earl45838142earl
egal55119432ega_l
enol45823822enol
fail74840242fail
fall75535312fall
farl76338552farl
foal76630922foal
fool75330592fool
gab67155992ga_b
gable85325522gable
gabs76740422gabs
gaby107123192gaby
gad57556652ga_d
gadi66329722gadi
gads67843382gads
gae46457702ga_e
gaed66031512gaed
gaen57329602gaen
gaes56348032gaes
gaff114828152gaff
gag57753632ga_g
gaga66625552gaga
gage65936102gage
gags66441062gags
gaily95020972gaily
gain56042162gain
gait56150192gait
gala55635162gala
gale56347322gale
galls64729322galls
gally95026172gally
galop84716212galop
gals57946502gals
gam67060062ga_m
gama77035512gama
gamb96331842gamb
gambol1138222gambol
game76644322game
gamp98833212gamp
gams76648882gams
gamy105427532gamy
gan48060122ga_n
gane55145292gane
gang66031962gang
ganof95420362ganof
gaoled84814492gaoled
gaoler73913572gaoler
gap67055612ga_p
gape75134512gape
gaps76042972gaps
gapy106320912gapy
gar47259902ga_r
garb75332672garb
gars55750742gars
gas48870252ga_s
gash86833022gash
gasp76227332gasp
gast56052562gast
gat46880512ga_t
gate55746572gate
gator64416032gator
gats56753442gats
gaud67025432gaud
gault65128482gault
gaum75726422gaum
gaun56427712gaun
gaur56723352gaur
gave84634052gave
gavel95815182gavel
gavot9321112gavot
gawk126716692gawk
gawp107618632gawp
gay76856492ga_y
gayal9312712gayal
gayly124513092gayly
gays87338022gays
gaze145032412gaze
gazoo153112872gazoo
gel45642432g_el
ghoul959052ghoul
gill56336182gill
girl56226552girl
glob76623392glob
glom75424382glom
glop76724632glop
glow85222522glow
gnarl65115572gnarl
go38748742g_o_
goa47343802g_oa
goad66830982goad
goals65521292goals
goas55239942goas
goat56250832goat
gob68950892g_ob
god57449792g_od
gold65430162g_old
golf85731182g_olf
goo47754772g_oo
good66531802good
goof85436872goof
gook96429602gook
goon57236172goon
goop75829482goop
goos57644912goos
gor47848262g_or
gos47155132g_os
got49870442g_ot
gox117137182g_ox
goy77844552g_oy
graal64316502graal
grail64622872grail
grog65923342grog
grok95819682grok
grot55942052grot
grow86127302grow
growl96115822growl
gul45832792g_ul
gull54828452gull
hail74839062hail
hall75741162hall
halo76437322halo
hao67251122hao_
haole84820082haole
harl75740002harl
haul75530452haul
idol56818632idol
jail115529092jail
jarl115828132jarl
kail85131492kail
kaon87521022kaon
lall45531312lall
mail65543442mail
mall64639362mall
marl66341612marl
maul64830712maul
mol56654592_mol
mool67533862mool
nail45838652nail
naoi46024632naoi
naos47429732naos
obol65220612obol
pail66141832pail
pal56761672pa_l
pall65039342pall
parol74826272parol
pawl95123262pawl
pol56449382_pol
pool65835952pool
rail46147762rail
sail45447162sail
sal36462882sa_l
sall44544682sall
salol55222142salol
saul45836522saul
sol37256622_sol
tael46030712tael
tail45443652tail
tall47240212tall
tao38358952tao_
taos45541002taos
taxol124011362taxol
tool46735682tool
vail75432552vail
viol76523592viol
wail75238822wail
wall76236102wall
waul76927312waul
wawl105321942wawl
wool76427372wool
yawl104918972yawl

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.0802233637.5
2DLD Change Limit298722010.95331345.2
3Display Results2012010.0464369.6
 (SQL Overall)1786912011.079165608.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.