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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

417 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
galiots8231132(None) 
galiot72322591galiot_
galipots1145211galipots
galliots9228681galliots
galoots82410791galoots
allots64019172_allots
ballots94116032ballots
gabions102410052gabions
gaits65726012ga_i_ts
galipot1049542galipot_
gallets83517402gallets
galliot82214132galliot_
gallipots1243772gallipots
gallons83015952gallons
galloots9268962galloots
gallops103211652gallops
gallous82813952gallous
gallows113513512gallows
galoot72719162galoot_
galops94712622gal_ops
gavots1038112ga_vots
glints75714212g_lints
griots74713642g_riots
talions7314112talions
talipots1045622talipots
aaliis6312903aali_is
abbots1039283_abbots
adios65822863_adio_s
adits66523713_adi_ts
ageists848493ageists
agios65919863_agio_s
agists75713173_agists
aglets73915683agl_ets
airts55626343_a_irts
aits46355533_a_i_ts
alants67722023_alants
aldols7109713_aldols
alerts64418223_alerts
algors7312553_algors
alias55834603_ali_as
alibis8311073_alibis
aliens65619213_aliens
alifs86121263_ali_fs
alights113211433_alights
aligns75312953_aligns
alines65735223_alines
aliquots1743643_aliquots
alist56136783_alist_
alit46155693_ali_t_
aliyas93911803_aliyas
aliyos9349533_aliyos
aliyot93611713_aliyot_
allods73615083_allods
allot54933873_allot_
allows94517683_allows
alloys94014563_alloys
almost81014433_almost
aloes54933673_al_oes
aloins65022203_aloins
altos55822953_alto_s
alts46639903_al__ts
anions64123033_anions
argots74116033_argots
ascots85312513_ascots
avions94114393_avions
axioms15408053_axioms
axions134713483_axions
bailors93212413bailors
bailouts1036613bailouts
baits76630583ba_i_ts
balboas113710073balboas
ballets93719513ballets
ballons93916963ballons
ballot84624093ballot_
basions94213953basions
bilious9310933bilious
blots75626173_bl_ots
cahoots1238473cahoots
calices114321693calices
calicoes123911593calicoes
calicos113913493calicos
califs114915893cali_fs
caliphs1436753caliphs
callets93821703callets
callous93516603callous
calos74431903cal_o_s
camions113916133camions
carious93320283carious
carrots9714623carrots
cations94524143cations
chariots1339393chariots
clifts11519153_clifts
cloots85113693_cloots
clots75627643_cl_ots
dacoits1079073dacoits
dakoits1245293dakoits
daltons8310403daltons
danios7314603danio_s
davits104012363davi_ts
delicts104012253delicts
delists84414173delists
dialists9411413dialists
dualists958243dualists
egalite8311563egali_te
egalites9310503egalites
elints65816423_elints
enlists749393enlists
faggots1234863faggots
fagots1039963fa_gots
faints94818783fa_ints
falcons1239123falcons
fallouts1137883fallouts
fallows133713973fallows
fanions103713073fanions
flints95617453_flints
flirts95411483_flirts
flits85625223_fli_ts
folios93915463folio_s
folious103710733folious
fylfots1642423fylfots
gabies93820733gabi_es
gabion93211033gabio_n
gaboons10289903gaboons
gadgets10348683gadgets
gadids95611823gadi_ds
gadis74825293gadi__s
gadoids1036873gadoids
gaiety10119373ga_iety
gains65729513ga_i_ns
gainst74914693ga_inst
gait56150193ga_i_t_
galagos938143galagos
galahs105512673gal_ahs
galas65731643gal__as
galaxes1538873galaxes
galeas74618513gal_eas
galeate83916783galeate
galenas83310343galenas
galeres83514333galeres
gales65442483gal__es
galette84212693galette
galettes93111153galettes
galilee8312213galilee
galilees936333galilees
galivants1344203galivants
gallants93310373gallants
gallate83417123gallate
gallates92815523gallates
galleons9258443galleons
gallet73630853gallet_
galleta8399643galleta
galletas9308133galletas
galleys11369713galleys
galliass935423galliass
gallicas1136933gallicas
gallies84122713gallies
gallipot1145943gallipot_
galliums1145963galliums
gallnuts943923gallnuts
gallon73715813gallo_n
galloon82910643galloon
galloons9289703galloons
galloot82814223galloot
gallop93311383gallo_p
galls64729323gal__ls
gallus74313203gal_lus
galop84716223gal_o_p
galore73514853gal_ore
galores82614323galores
galosh1038563gal_osh
gals57946503gal___s
galyacs1335273galyacs
galyaks1534623galyaks
gambits12399723gambits
gambols1238593gambols
gamiest102816223gamiest
gamines103618463gamines
gamings114610913gamings
gamins94420043gami_ns
gammons1237973gammons
gamuts958783ga_muts
ganglions1144063ganglions
gannets83811443gannets
ganofs104010293ga_nofs
ganoids939333ganoids
gaols66717573ga__ols
garcons102411643garcons
gargets94614573gargets
garlics1038013garli_cs
garnets84115403garnets
garote7717953ga_rote
garotes8614563ga_rotes
garrets84413623garrets
garrons82713463garrons
garrote8510103garrote
garrotes969363garrotes
gascons10289103gascons
gaseous839503gaseous
gaskets12348153gaskets
gaslights1463753gaslights
gaslit7513503gasli_t_
gasts66628633ga__sts
gatings95212823gatings
gators74115833ga_tors
gats56753443ga___ts
gaults74112783ga_ults
gavials1136603gavials
gavot9321123ga_vot_
gazoos163010223ga_zoos
gelants82611443gelants
gelatos83111513gelatos
gelts65924613gel__ts
gemots93712153g_emots
gifts96214963g__ifts
giglots9367863giglots
gigots83911953g_igots
gilts64924263g__ilts
girts65423623g__irts
gists66026193g__ists
gits55744593g__i_ts
glaires84010133glaires
glairs75211333glai_rs
glaives11347833glaives
glamors1068113glamors
gleets75315053g_leets
glias64618493g_li_as
glides84518863g_lides
gliffs13436323g_liffs
glimes94717523g_limes
glims87417673g_li_ms
glint66830183g_lint_
glinty106910693g_linty
glioma935953g_lioma
gliomas1035333g_liomas
glitz154916373g_li_tz
gloats74515423g_loats
globs85616403g_l_obs
gloms85219783g_l_oms
glooms96211683g_looms
glops85619553g_l_ops
gloss64319623g_l_oss
glost65422933g_l_ost
glosts74513813g_losts
glouts74414713g_louts
glows95518033g_l_ows
gluons738503g_luons
gluts66120133g_l_uts
goalies8316023goali_es
goalpost1143853goalpost
goalposts1252163goalposts
goliath1145933goliath
goliaths1244223goliaths
gracious1138593gracious
grifts104511683g_rifts
griot65328413g_riot_
grists74716483g_rists
grits65529583g_ri_ts
grots65025853g__rots
guilts74111233g_uilts
gullets84013713gullets
guyots1036003g_uyots
habits113014653habi_ts
haints94417583ha_ints
halibuts1364443halibuts
halides113416663halides
halidoms1485823halidoms
halids104016133hali_ds
halite93624233hali_te
halites103221193halites
halitus10339963halitus
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hallo_s
hallot95426783hallot_
halloth134111253halloth
hallows134417393hallows
haloes94623863hal_oes
haloids113012553haloids
halons95720713hal_ons
halos85230253hal_o_s
halts85230103hal__ts
haricots1347333haricots
harlots103413293harlots
haviors1347383haviors
helios94816633helio_s
helots95217703hel_ots
heriots10312063heriots
holists104413963holists
idiots768643_idiots
jabots1538883ja_bots
jailors14328753jailors
jalops15329593jal_ops
kalians11310183kalians
kalifs134410983kali_fs
kaliphs1634293kaliphs
kaliums1336603kaliums
kations114013663kations
lariats7615053lariats
legalists1047943legalists
lifts85719063__lifts
lilts55822803__lilts
lints57137193__lints
lions55923213__lions
lists56628693__lists
lits46252493__li_ts
loots55431423__loots
lots47652093__l_ots
maggots1136563maggots
magots9312363ma_gots
maillots1037473maillots
maists85817573ma_ists
malices114316623malices
maligns1038133maligns
malines93625603malines
malisons1048783malisons
mallets93318493mallets
mallows123714323mallows
maloti8313213mal_oti
maltols939403maltols
malts76331753mal__ts
manihots13126443manihots
maniocs113611443maniocs
manitos9314053manitos
marmots11311513marmots
mascots113910343mascots
melilots1046553melilots
nasions73112383nasions
nations74720563nations
olios54520853_olio_s
oralists8611803oralists
paints85921833pa_ints
paletots1047803paletots
palets85122313pal_ets
paliest93021603paliest
palings103915823palings
pallets93919303pallets
pallors9314363pallors
palmists12268813palmists
papists112110453papists
parrots9312743parrots
patios85221783patio_s
patriots1038053patriots
paviors1237603paviors
pilots84018873pil_ots
plaints94012053plaints
plaits83816473plai_ts
plots75025673_pl_ots
polios84019723polio_s
racists92613323racists
radios74018673radio_s
rapists92510753rapists
rations74123433rations
ratios64922673ratio_s
realists83014843realists
reallots837993reallots
relicts94414593relicts
relists73817053relists
riots54922013__riots
sabots8314703sa_bots
sadists83310853sadists
sailors73213723sailors
saints65122423sa_ints
salients839563salients
salinas73116093salinas
salines74029413salines
salivas10309603salivas
sallets73719653sallets
sallows103915553sallows
salmons93713263salmons
salols64017873sal_ols
salons63823693sal_ons
saloons74415323saloons
saloops93510133saloops
salts55431883sal__ts
salvoes102811313salvoes
salvors103910913salvors
salvos94613383salvo_s
sanious7514103sanious
saviors1058993saviors
sealifts1135473sealifts
shallots11319503shallots
slits56128853_sli_ts
slots54830533_sl_ots
solions7513753solions
splints94511743splints
splits85416413spli_ts
tailors73212393tailors
taints64520533ta_ints
talcous939483talcous
talents7312013talents
talion6317713talio_n
talipes9611603talipes
talipot949723talipot_
tallits73215993tallits
tallols73311363tallols
tallows103313743tallows
talons64019443tal_ons
tanists7313653tanists
tarots66422993ta_rots
uplifts12424773uplifts
valets93715623val_ets
valiants1137793valiants
valines104520213valines
valises103516263valises
valors93413773val_ors
various103113103various
waists97415453wa_ists
waits88333523wa_i_ts
walies95324523wali_es
walkouts1544253walkouts
wallets103914833wallets
wallops123410413wallops
wallows133613533wallows
walnuts1033843walnuts
wanions104011373wanions
zealots1636763zeal_ots

Search took 7 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.406440125.6
2DLD Change Limit1340274175.95322514.2
3Display Results4174170.1402978.6
 (SQL Overall)1786914176.49927495.2
 
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.