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

287 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
hajji1467745(None) 
hadji16839871hadji
haji148520181ha_ji
hajj138312471hajj_
hajjis15485881hajjis
hadj155818672hadj_
hadjis17439632hadjis
haj138140602ha_j_
hajes155420942hajes
hajis156716272hajis
hajjes15485242hajjes
kanji1647452kanji
aalii5316123aalii
abri65522213_abri
ahi68040233_a_hi
ai211288393_a__i
ajar116217703_ajar
ajee115928233_ajee
ami56646803_a_mi
ani37751173_a_ni
anti45536363_anti
asci66519143_asci
bani65334953ba_ni
banjo143812443banjo
bassi77019323bassi
bhakti1544323bhakti
cacti9318633cacti
cadi75732173ca_di
cajon144513903cajon
campi116217783campi
carpi94319393carpi
chadri1238133chadri
chai95929903cha__i
dashi95013113dashi
farci105919313farci
fuji144112003_fuji
gaddi85211633gaddi
gadi66329723ga_di
gadje1457743gadje
gadjo1436913gadjo
gaijin1445973gaijin
ganja131410003ganja
garni6315703garni
gharri10386163gharri
ghazi1837433gha_zi
ha510259943ha___
haaf106227733ha_af
haafs115711163haafs
haar77323493ha_ar
haars85620473haars
habit103027013habit
habu97325483ha_bu
habus106317143habus
hacek145411843hacek
hack135134543ha_ck
hackie154615623hackie
hacks144928713hacks
had77658763ha__d
hadal95518123hadal
hade85440193ha_de
haded105227623haded
hades96035113hades
hadjee174111823hadjee
hadjes175210403hadjes
hadst93220223hadst
hae67364003ha__e
haed86338583ha_ed
haem95730983ha_em
haemic133210083haemic
haemin113412663haemin
haems105517013haems
haen76229453ha_en
haes77651023ha_es
haet75659503ha_et
haets86525123haets
haffit1538533haffit
hafiz20611213hafiz
haft105941843ha_ft
hafts116219463hafts
hag77255743ha__g
haggis11209513haggis
hags86740843ha_gs
hah910655223ha__h
haha107821063ha_ha
hahas117118443hahas
hahs108333363ha_hs
haik115526983ha_ik
haika125313793haika
haiks125120933haiks
haiku126113693haiku
hail74839063ha_il
hails85231643hails
haint85436323haint
hair76330143ha_ir
hairs86225173hairs
hairy115316833hairy
hake115637843ha_ke
hakes126034303hakes
hakim14311823hakim
haku116923893ha_ku
hakus125114113hakus
halal85623593halal
hale76052833ha_le
haled95335823haled
haler85033523haler
hales85449843hales
half106238453ha_lf
halid94424973halid
hall75741163ha_ll
hallo85127553hallo
halls85633783halls
halm95834973ha_lm
halma108219253halma
halms105225213halms
halo76437323ha_lo
haloid104317753haloid
halon86124863halon
halos85230253halos
halt76056303ha_lt
halts85230103halts
halva115414433halva
halve114818923halve
ham86363283ha__m
hamal104623103hamal
hame97043133ha_me
hames106138703hames
hammy155113433hammy
hams96446133ha_ms
hamuli1137053hamuli
hamza19139773hamza
hance105424153hance
hand86833703ha_nd
hands95327383hands
handy125520873handy
hang85535543ha_ng
hangs95726723hangs
hank115134133ha_nk
hankie133915713hankie
hanks126226863hanks
hanky155418293hanky
hansa85416783hansa
hanse85722793hanse
hant75461583ha_nt
hants86335403hants
hao67251123ha__o
haole84820083haole
hap87360053ha__p
hapax1739323hapax
haply135915063haply
happy155813533happy
haps96443463ha_ps
haptic13511883haptic
hard85443503ha_rd
hards96435653hards
hardy125622063hardy
hare76255733ha_re
hared95742183hared
harem104924453harem
hares86255543hares
hark115237393ha_rk
harks126333433harks
harl75740003ha_rl
harls85634503harls
harm95637793ha_rm
harmin113117393harmin
harms106829013harms
harp96134283ha_rp
harpin113614383harpin
harps105926863harps
harpy136418203harpy
harry115322953harry
harsh116418053harsh
hart76865773ha_rt
harts88441593harts
has67372653ha__s
hash106936503ha_sh
hasp96627293ha_sp
hasps105114643hasps
hast76259483ha_st
haste85927863haste
hasty115718763hasty
hat67289963ha__t
hatch135719593hatch
hate78450173ha_te
hated95734023hated
hater85034753hater
hates86742573hates
hath105933913ha_th
hatpin112610603hatpin
hats76858253ha_ts
haugh125114053haugh
haul75530453ha_ul
haulm104415413haulm
hauls86123733hauls
haunt85229133haunt
haut75949733ha_ut
haute89521613haute
have106137073ha_ve
haven114718533haven
haver115124463haver
haves116034873haves
havoc1337183havoc
haw97153273ha__w
hawed126025423hawed
hawk145521153ha_wk
hawkie163810093hawkie
hawks155415703hawks
haws106439443ha_ws
hawse116015123hawse
hay97358773ha__y
hayed125822013hayed
hayer114620243hayer
hayey144812533hayey
hays106138073ha_ys
hazan173813613hazan
haze164833393ha_ze
hazed185222203hazed
hazel176414813hazel
hazer174820233hazer
hazes174928323hazes
hazy1918119193ha_zy
hi57947583h___i
hijab1736803hijab
hijra1535643hijra
hili75626633h_ili
hongi96715853hongi
houri85915233houri
iambi95512193iambi
kadi96224823ka_di
kaki76520913ka_ki
kami105823643ka_mi
kanjis1735963kanjis
kauri93811843kauri
khadi1367603kha_di
khaki1157643kha_ki
koji155611113_koji
laari54415713laari
lanai5319573lanai
lari45839153la_ri
lassi56316853lassi
lathi85417203lathi
lati46438273la_ti
magi76329523ma_gi
major145212923major
maqui16249953maqui
masjid16187313masjid
maxi137023553ma_xi
naevi867873naevi
naoi46024633na_oi
nazi136219873na_zi
padi76331783pa_di
padri85815163padri
palpi95414553palpi
pappi84810893pappi
pardi85723953pardi
phalli1148263phalli
punji1438203punji
qadi145621103qa_di
rabbi93113173rabbi
radii64016413radii
ragi56032283ra_gi
rai37658223ra__i
raj105740223ra_j_
raja117918683ra_ja
rajah155711423rajah
rajas127317723rajas
rajes125022783rajes
raki87127833ra_ki
rami66034093ra_mi
rani46640103ra_ni
sadi55834643sa_di
sajou12311693sajou
saki85628473sa_ki
salmi7815863salmi
sari45444043sa_ri
sati45539323sa_ti
shanti94014073shanti
shoji15419943shoji
taj106442193ta_j_
tajes124920693tajes
tali46837163ta_li
tarsi55222173tarsi
taxi117124763ta_xi
thalli958913thalli
vagi86719363va_gi
wadi86228173wa_di
yagi86922243ya_gi

Search took 5 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 Filter178691836670.1231452772.4
2DLD Change Limit836672874.62618086.3
3Display Results2872870.0763776.3
 (SQL Overall)1786912874.82537034.4
 
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.