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

240 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
hajjis1548589(None) 
hadjis17439651hadjis
hajis156716281ha_jis
hajjes15485241hajjes
hajji14677461hajji_
hadjes175210402hadjes
hadji16839892hadji_
haggis11209512haggis
hajes155420942ha_jes
haji148520192ha_ji_
hajj138312472hajj__
kanjis1735962kanjis
aaliis6312903aaliis
abris75722603_abris
aegis6316783_aegis
ahis76135383_a_his
ais39083573_a__is
amis66445323_a_mis
anis45746463_a_nis
antis55033313_antis
aphis105917133_aphis
apsis75718293_apsis
arris56824683_arris
arsis55722423_arsis
aspis74618143_aspis
auris55331533_auris
axis116127913_a_xis
banjos15378893banjos
basis75429863ba_sis
bhaktis1633433bhaktis
caddis104613383caddis
cadis84428503ca_dis
capris10415083capris
cassis84818853cassis
caulis85320083caulis
chablis14368563chablis
chais107530313cha__is
challis124613463challis
chamois143512193chamois
chassis123910663chassis
dais57040703da__is
dashis104414393dashis
fujis15379243_fujis
gaddis94211373gaddis
gadis74825293ga_dis
gaijin1445983gaijin
ganjas14149113ganjas
gharris11306433gharris
ghazis1935203gha_zis
haafs115711163ha_afs
haars85620473ha_ars
habit103027023ha_bit
habits113014653habits
habus106317143ha_bus
haceks15447863haceks
hackie154615623hackie
hackies163418243hackies
hacks144928713ha_cks
hades96035113ha_des
hadj155818673hadj__
hadjee174111823hadjee
hadjees18356383hadjees
haemic133210083haemic
haemin113412663haemin
haemins122811403haemins
haems105517013ha_ems
haeres94017033haeres
haes77651023ha__es
haets86525123ha_ets
haffit1538533haffit
haffits1636193haffits
hafiz20611213ha_fiz
hafts116219463ha_fts
hagfish17227613hagfish
haggish15207473haggish
hags86740843ha__gs
hahas117118443ha_has
hahs108333363ha__hs
haik115526983ha__ik
haiks125120933ha_iks
haikus13538293haikus
hail74839063ha__il
hails85231643ha_ils
haimish1537753haimish
haints94417583haints
hair76330143ha__ir
hairs86225173ha_irs
haj138140603ha_j__
hakes126034303ha_kes
hakim14311833ha_kim
hakims1537303hakims
hakus125114113ha_kus
halals95018313halals
halers94926913halers
hales85449843ha_les
halid94424983ha_lid
halids104016133halids
hallos95425103hallos
halls85633783ha_lls
halmas117017893halmas
halms105225213ha_lms
haloes94623863haloes
haloid104317763haloid
haloids113012553haloids
halons95720713halons
halos85230253ha_los
halts85230103ha_lts
halvas124714173halvas
halves124717093halves
hamals114816823hamals
hames106138703ha_mes
hams96446133ha__ms
hamzas20119013hamzas
hances115621283hances
hands95327383ha_nds
hangs95726723ha_ngs
hankie133915713hankie
hankies143617763hankies
hanks126226863ha_nks
hansas94616043hansas
hanses95022633hanses
hants86335403ha_nts
haoles94919803haoles
haps96443463ha__ps
haptic13511893haptic
harass9313943harass
hardies114923233hardies
hards96435653ha_rds
harems115513823harems
hares86255543ha_res
harks126333433ha_rks
harls85634503ha_rls
harmin113117393harmin
harmins123716723harmins
harms106829013ha_rms
harpies123818323harpies
harpin113614383harpin
harpins123615703harpins
harpist12312363harpist
harps105926873ha_rps
harries103525493harries
harts88441593ha_rts
has67372653ha___s
hashes125024803hashes
hashish1238353hashish
hasps105114643ha_sps
hastes95727073hastes
haters94930403haters
hates86742573ha_tes
hatpin112610613hatpin
hatpins123410643hatpins
hats76858253ha__ts
haughs13408563haughs
haulms11558503haulms
hauls86123733ha_uls
haunts95614393haunts
havens124514043havens
havers124721483havers
haves116034873ha_ves
havocs1435653havocs
hawkie163810093hawkie
hawkies173311243hawkies
hawkish2036553hawkish
hawks155415703ha_wks
haws106439443ha__ws
hawses125113993hawses
hayers124415943hayers
hays106138073ha__ys
hazans183411653hazans
hazels185710083hazels
hazers184615953hazers
hazes174928323ha_zes
hijabs1833083hijabs
hijras1635773hijras
his66359503h___is
houris94514583houris
hubris11218973hubris
hybris14247003hybris
kadis105921063ka_dis
kakis86116843ka_kis
kanji1647453kanji_
kauris103611533kauris
khadis1446913kha_dis
khakis1265853kha_kis
kojis16468443_kojis
lanais6316793lanais
lapis76223153la_pis
laris54737463la_ris
lassis65216703lassis
lathis95516173lathis
majors154511093majors
mantis83926033mantis
maquis17249483maquis
masjid16187323masjid
masjids17175403masjids
mavis105622723ma_vis
maxis145721563ma_xis
nabis76020583na_bis
naris55735293na_ris
nazis145216083na_zis
oasis56422553oa_sis
padis86227143pa_dis
palais8420423palais
paris75145943pa_ris
parvis116114803parvis
pastis84924323pastis
patois84319363patois
pavis106422733pa_vis
phasis114614923pha_sis
punjis1536693punjis
qadis155917853qa_dis
rabbis102613163rabbis
rachis114017653rachis
ragis66325603ra_gis
rais45252623ra__is
rajahs16497663rajahs
rajas127317723ra_jas
rajes125022783ra_jes
rakis95323443ra_kis
ranis55235833ra_nis
raphis114014323raphis
rhachis1555693rhachis
sadis64930853sa_dis
sajous13310583sajous
sakis95323673sa_kis
salmis8514273salmis
saris54544953sa_ris
satis55633683sa_tis
shamois123210423shamois
shantis103313103shantis
shojis16348493shojis
tabbis102910863tabbis
tajes124920693ta_jes
tallis63319963tallis
tamis76728733ta_mis
tapis75028863ta_pis
taxis126821973ta_xis
wadis95223963wa_dis
whatsis1335253whatsis
yagis95416573ya_gis

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 Filter1786911127160.436409841.7
2DLD Change Limit1127162405.79619447.2
3Display Results2402400.0763157.9
 (SQL Overall)1786912406.30828327.7
 
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.