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

458 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
ghazis193519(None) 
ghazi1837431ghazi_
ghazies2036911ghazies
chais107530312cha_is
gadis74825292g_adis
gazes155425912g_azes
gharris11306432gharris
ghats95818612gha_ts
ghauts10447782ghauts
ghis85020162gh__is
glacis94012132glacis
glazes165315642glazes
gratis74819242gratis
grazes164519642grazes
hajis156716282_hajis
hazes174928322_hazes
khadis1446912khadis
khakis1265852khakis
nazis145216082_nazis
phasis114614922phasis
abatis84317933abatis
afghanis1542863afghanis
aghas97014873agha__s
ahis76135383__ahis
ais39083573__a_is
amazes175613473amazes
amis66445323__amis
anis45746463__anis
axis116127913__axis
basis75429863_basis
bhaktis1633423bhaktis
bhangs12449663bhangs
bialis83617163bialis
blazes174817353blazes
brazas175812433brazas
brazes175522193brazes
brazil1779623brazil
brazils1867753brazils
cadis84428503_cadis
chablis14368563chablis
chads116122233cha_ds
chafes145017913chafes
chaffs17459613chaffs
chai95929903cha_i_
chain105723673cha_in
chains114819703chains
chair105519633cha_ir
chairs114916183chairs
chaise114916413cha_ise
chalks155412143chalks
challis124613463challis
chamisa14328853chamisa
chamise143612853chamise
chamiso14348653chamiso
chamois143512193chamois
champs154915683champs
chams126028503cha_ms
changs125215373changs
chants115020393chants
chaos105622863cha_os
chapes135421873chapes
chaps125326063cha_ps
charas114223613charas
chards125119733chards
chares115631803chares
charism14712203charism
charks155219703charks
charms135218843charms
charrs115219193charrs
chars105936643cha_rs
charts115823093charts
chases115128233chases
chasms135513143chasms
chassis123910663chassis
chats105730093cha_ts
chaws135022463cha_ws
chays135319743cha_ys
chazan20269133chazan
chazans21268123chazans
chilis115517873chilis
chis95933313ch__is
coatis85122603coatis
crasis85020473crasis
crazes174720133crazes
crazies183413853crazies
dais57040703_da_is
dazes155024143_dazes
dhaks13479703dha_ks
dhals95415443dha_ls
dhobis1236103dhobis
dhotis1038963dhotis
dhutis1035933dhutis
diazin1639163diazin
diazins1739183diazins
fazes175527213_fazes
feazes184514173feazes
frazil1847223frazil
frazils1956123frazils
gabies93820733g_abies
gabs76740423g_a_bs
gaddis94211373gaddis
gadi66329723g_adi_
gadid85517383g_adid
gadids95611823g_adids
gads67843383g_a_ds
gaes56348033g_a_es
gaffs124914653g_affs
gages74529973g_ages
gags66441063g_a_gs
gain56042163g_a_in
gains65729513g_ains
gait56150193g_a_it
gaits65726013g_aits
galas65731643g_alas
gales65442483g_ales
galls64729323g_alls
gals57946503g_a_ls
gamas85431363g_amas
gambs105721123g_ambs
games86238553g_ames
gamic103916203g_amic
gamin84423003g_amin
gamins94420043g_amins
gamps105323713g_amps
gams76648883g_a_ms
gangs76222573g_angs
gaols66717573g_aols
gapes86030823g_apes
gaps76042973g_a_ps
garbs86321413g_arbs
garish104516923g_arish
gars55750743g_a_rs
gas48870253g_a__s
gases65633993g_ases
gasps85415483g_asps
gasts66628633g_asts
gates65939513g_ates
gats56753443g_a_ts
gauds75717723g_auds
gaums86217073g_aums
gaurs66317993g_aurs
gauss65613453g_auss
gauzes164710633gauzes
gawks136811633g_awks
gawps115911013g_awps
gays87338023g_a_ys
gazar154612983g_azar
gazars164811553g_azars
gaze145032413g_az_e
gazed165520333g_azed
gazer155720073g_azer
gazers164516303g_azers
gazing174717173g_azing
gazoo153112873g_azoo
gazoos163010223g_azoos
gears64628693gea_rs
gelatis83313513gelatis
gharial1137343gharial
gharials1245123gharials
gharri10386163gharri
gharries12318203gharries
gharry13546273gharry
ghast95621223gha_st
ghat86435283gha__t
ghaut95919433gha_ut
ghees95215553gh_ees
ghi77019883gh__i_
ghiblis1353343ghiblis
ghosts10489273ghosts
ghouls1036043ghouls
ghylls1335143ghylls
giants74713503giants
glaces94218023glaces
glades84820343glades
glads75620613gla_ds
glair65313553gla_ir
glairs75211333glairs
glams85822933gla_ms
glands85314403glands
glans65125833gla_ns
glares75518863glares
glass65518133gla_ss
glaze155418163glaz_e
glazed174711773glazed
glazer164212263glazer
glazers174410043glazers
glazier17409353glazier
glaziers18406563glaziers
glaziest18227913glaziest
glazily2035383glazily
glazing183611003glazing
glazings19325753glazings
glazy187410983glaz_y
glozes164313353glozes
gnarls74210773gnarls
gnarrs7407663gnarrs
gnars66718853gna_rs
gnats65217713gna_ts
gnaws96311143gna_ws
gnosis75711213gnosis
goads77022853goa_ds
goalie7413163goalie
goalies8316023goalies
goals65521293goa_ls
goas55239943goa__s
goatish1139563goatish
goats65527303goa_ts
graals74112913graals
grabs85719693gra_bs
graces94523493graces
grades84926313grades
gradin83517483gradin
gradins93416233gradins
grads75625753gra_ds
gradus84411223gradus
grafts105013253grafts
grail64622873gra_il
grails77518783grails
grain65126253gra_in
grains74223093grains
gramas94317203gramas
gramps114114273gramps
grams85327313gra_ms
grands84218243grands
grans64832543gra_ns
grants73722473grants
grapes95123123grapes
graphs124510153graphs
grasps9489253grasps
grass66125203gra_ss
grates75429893grates
gratin74520583gratin
gratins84119183gratins
graves104624003graves
gravid113710983gravid
gravies11314093gravies
grayish1437813grayish
grays95621333gra_ys
graze155820053graz_e
grazed174115913grazed
grazer164815763grazer
grazers175112453grazers
grazier173611133grazier
graziers18387123graziers
grazing183514553grazing
grazings19337263grazings
grazioso1862793grazioso
guacos94410313guacos
guanin7610803guanin
guanins8810013guanins
guanos73811993guanos
guans64419443gua_ns
guards84611573guards
guars65021053gua_rs
guavas1037163guavas
gyozas1933613gyozas
haafs115711163_haafs
haars85620473_haars
habit103027023_habit
habits113014653_habits
habus106317143_habus
hacks144928713_hacks
hades96035113_hades
hadjis17439653_hadjis
haems105517013_haems
haes77651023_ha_es
haets86525123_haets
hafiz20611213_hafiz
hafts116219463_hafts
haggis11209513_haggis
hags86740843_ha_gs
hahas117118443_hahas
hahs108333363_ha_hs
haik115526983_ha_ik
haiks125120933_haiks
hail74839063_ha_il
hails85231643_hails
hair76330143_ha_ir
hairs86225173_hairs
hajes155420943_hajes
haji148520193_haji_
hajjis15485893_hajjis
hakes126034303_hakes
hakim14311823_hakim
hakims1537303_hakims
hakus125114113_hakus
hales85449843_hales
halid94424983_halid
halids104016133_halids
halls85633783_halls
halms105225213_halms
halos85230253_halos
halts85230103_halts
hames106138703_hames
hams96446133_ha_ms
hamzas20119013_hamzas
hands95327383_hands
hangs95726723_hangs
hanks126226863_hanks
hants86335403_hants
haps96443463_ha_ps
hards96435653_hards
hares86255543_hares
harks126333433_harks
harls85634503_harls
harms106829013_harms
harps105926863_harps
harts88441593_harts
has67372653_ha__s
hasps105114643_hasps
hates86742573_hates
hats76858253_ha_ts
hauls86123733_hauls
haves116034873_haves
hawks155415703_hawks
haws106439443_ha_ws
hays106138073_ha_ys
hazan173813613_hazan
hazans183411653_hazans
haze164833393_haz_e
hazed185222203_hazed
hazel176414813_hazel
hazels185710083_hazels
hazer174820233_hazer
hazers184615953_hazers
hazier184712403_hazier
haziest193313003_haziest
hazily2179063_hazily
hazing194218553_hazing
hazings20378343_hazings
hazy1918119193_haz_y
his66359503_h__is
kadis105921063_kadis
kakis86116843_kakis
khadi1367603khadi_
khafs15648843kha_fs
khaki1157643khaki_
khalif1657833khalif
khalifs1754073khalifs
khans124615173kha_ns
khaphs18394323khaphs
khats125316013kha_ts
khazen2233773khazen
khazens2332663khazens
khis117017983kh__is
lapis76223153_lapis
laris54737463_laris
lazes145129573_lazes
lazies154418783_lazies
mavis105622723_mavis
maxis145721563_maxis
mazes165632173_mazes
myasis114010473myasis
nabis76020583_nabis
naris55735293_naris
nazi136219873_nazi_
oasis56422553_oasis
oghamic1544043oghamic
oghamist1444753oghamist
oghams1245853ogha_ms
okapis1235393okapis
oxalis1339223oxalis
padis86227143_padis
paris75145943_paris
pavis106422733_pavis
phages125213513phages
pharos11312063pharos
phases114618403phases
phasic133612053phasic
phatic133014403phatic
phis95724903ph__is
phizes20389133phizes
physis14359663physis
plazas17409913plazas
praxis154012253praxis
qadis155917853_qadis
quais144618393qua_is
ragis66325603_ragis
rais45252623_ra_is
rakis95323443_rakis
ranis55235833_ranis
razes145032703_razes
rhachis1555693rhachis
sadis64930853_sadis
sakis95323663_sakis
saris54544953_saris
satis55633673_satis
shacks154817563shacks
shades105924533shades
shads95124483sha_ds
shafts125411433shafts
shags95123863sha_gs
shahs115919513sha_hs
shakes135024593shakes
shakos134912183shakos
shales94731253shales
shamas113717943shamas
shames114726223shames
shamois123210413shamois
shamos114216983shamos
shams105829413sha_ms
shamus114112813shamus
shanks135315583shanks
shantis103313093shantis
shapes115124943shapes
shards104319173shards
shares95236413shares
sharia93116723sharia
sharias102516003sharias
sharif122917113sharif
sharifs13279903sharifs
sharks135019723sharks
sharns95516983sharns
sharps115516083sharps
shauls94913113shauls
shaves125224933shaves
shavie124312413shavie
shavies134213203shavies
shawls125411973shawls
shawms14579563shawms
shaws116226263sha_ws
shays116021433sha_ys
shazam2046613shazam
shogis103810933shogis
shojis16348483shojis
shris84221443sh_ris
smazes174311663smazes
spahis11310383spahis
stasis63116873stasis
swamis114212293swamis
tamis76728733_tamis
tapis75028863_tapis
taxis126821973_taxis
thacks154311923thacks
thanes94918983thanes
thanks134313133thanks
tharms115712243tharms
thaws116515463tha_ws
thesis94913733thesis
thiazin1945473thiazin
thiazins2045313thiazins
this76027383th__is
tsadis7429133tsadis
umamis1038273umamis
unais53420773una_is
uraris63817273uraris
wadis95223963_wadis
whacks184610483whacks
whales124716943whales
whams135515643wha_ms
whangs13439723whangs
whaps135115163wha_ps
wharfs1546373wharfs
whats117718993wha_ts
whatsis1335243whatsis
whaups14405753whaups
whosis1237163whosis
yagis95416573_yagis

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127164586.89016359.4
3Display Results4584580.1403271.4
 (SQL Overall)1786914587.15624970.8
 
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.