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

148 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
hamzahs2413437(None) 
hamzah23135561hamzah_
hamzas20119011hamza_s
amahs107819062_am_ahs
hallahs133912462hallahs
halvahs16417532halvahs
hamals114816832ham_als
hammals14409232hammals
hammams13386442hammams
hamza19139772hamza__
hazans183411652ha_zans
hazmats2136602hazmats
hazzans18215782hazzans
huzzahs2143082huzzahs
matzahs2134482matzahs
aahs716428563_a__ahs
almahs118611613_almahs
amah98927493_am_ah_
amas67746293_am_a_s
amass77119683_am_ass
amazes175613473_amazes
amias75831473_amia_s
ayahs116813523_a_yahs
azans146516883_a_zans
baizas173810823baiza_s
banzais1837163banzais
bazars174613113ba_zars
bimahs13508303bim_ahs
camas96333523cam_a_s
camass104114183cam_ass
casbahs1436463casbahs
chalahs15289883cha_lahs
challahs16377563challahs
champacs1934633champacs
champaks2134103champaks
chazans21268123cha_zans
chazzans21234503chazzans
damans94715983dam_ans
damars93815003dam_ars
dammars12308193dammars
galahs105512683ga_lahs
gamas85431363gam_a_s
gamays126310913gam_ays
gambas115817513gamba_s
gammas115714693gamma_s
ganjahs18104003ganjahs
gazars164811553ga_zars
haafs115711163ha__afs
haars85620473ha__ars
hadiths1436023hadiths
hahas117118443ha_ha_s
hahs108333363h___ahs
halakahs18426633halakahs
halalahs14367443halalahs
halals95018313ha_lals
halavahs17415793halavahs
hallah124115403hallah_
halmas117017893halma_s
halvah15499833halvah_
halvas124714173halva_s
hamada1239923ham_ada
hamadas1339673hamadas
hamal104623113ham_a_l
hamate113319833ham_ate
hamates122917683hamates
hamaul114210873ham_aul
hamauls12387823hamauls
hames106138703ham__es
hamlets123211403hamlets
hammada1545093hammada
hammadas1644793hammadas
hammal134512063hamma_l
hammam12419333hamma_m
hammers144216063hammers
hampers143616953hampers
hams96446133ham___s
hamulus1235323hamulus
hangars114313493hangars
hansas94616043hansa_s
harass9313943ha_rass
hardass1139753hardass
hartals10313023hartals
haughs13408563ha_ughs
hazan173813613ha_za_n
hazard1938403ha_zard
hazards2037463ha_zards
hazels185710083ha_zels
hazers184615953ha_zers
hazes174928323ha_z_es
hazmat20312263hazma_t
hazzan17236803hazza_n
hijrahs2043443hijrahs
hookahs17446663hookahs
hoorahs13399613hoorahs
horahs126313873h_orahs
houdahs1434243houdahs
howdahs1733613howdahs
humans112312433hum_ans
humphs16528163hum_phs
huppahs1743333huppahs
hurrahs13336773hurrahs
hutzpahs2541443hutzpahs
huzzah2044423huzzah_
huzzas1735863huzza_s
hymnals1543533hymnals
jarrahs1735453jarrahs
kasbahs1634363kasbahs
lamas75532793lam_a_s
lamedhs13444703lamedhs
lamias85020613lamia_s
lampads12477623lampads
lampas106615953lampa_s
lazars153812393la_zars
mamas95930773mam_a_s
mambas125716243mamba_s
mammals10389273mammals
mammas94616403mamma_s
mamzers20409163mamzers
matsahs1236563matsahs
matzah2035963matzah_
matzas1749703matza_s
matzohs2134373matzohs
oompahs1434263oompahs
pampas124913993pampa_s
pardahs13289673pardahs
pariahs123812343pariahs
rajahs16497663ra_jahs
rayahs12579193ra_yahs
sambals115213483sambals
sambars115113843sambars
sambas104219263samba_s
samechs14285353samechs
samekhs16303923samekhs
sampans112411003sampans
shamans123610903sham_ans
shamas113717943sham_a_s
shammas14358723shamma_s
shammash18293753shammash
shariahs14206393shariahs
tamals84116633tam_als
tambacs13219363tambacs
tambaks15218153tambaks
tampans113310983tampans
tarzans16329923tarzans
tazzas1436283tazza_s
wallahs13409473wallahs
zamias174212923zamia_s
zanzas1487053zanza_s

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271486.84319586.0
3Display Results1481480.0463217.4
 (SQL Overall)1786911487.31224438.0
 
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.