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

248 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
ahimsa113478(None) 
ahimsas1234781ahimsas
ahis76135382ahi_s_
aims67738182a_ims_
anima74620072anim_a
animas84418722animas
chimla1337592chimla
hims95230972_hims_
shiksa1394652shiksa
shims104422552shims_
whims134515332whims_
whimsy17375222whimsy
aboma91114603abom_a
abomas101113583abomas
abomasa11114613abomasa
achiest12315183achiest
acids87121003acids_
adios65822863adios_
adits66523713adits_
aftosa996573aftosa
agama85815583agam_a
agamas97413453agamas
agios65919863agios_
agism84614063agi_sm
agisms9399393agisms
agist66325583agi_st
agita6315423agi_ta
agitas7310593agitas
agma77623263a_gm_a
agmas85919873a_gmas
aha611246643ah___a
ahem97225363ahem__
ahi68040233ahi___
ahing98928353ahi_ng
ahorse9311513ahorse
ahs68644823ah__s_
aids57846353a_ids_
ails45654713a_ils_
aim57858213a_im__
aimed85626053a_imed
aimer75926823a_imer
ains46158883a_ins_
airs46447423a_irs_
ais39083573a_i_s_
aits46355533a_its_
ajiva1586803aji_va
ajivas1655133ajivas
akimbo1443393akimbo
alias55834603alias_
alifs86121263alifs_
alist56136783ali_st
aliya83713483ali_ya
aliyas93911803aliyas
alma66333023a_lm_a
almas76629773a_lmas
alms65834923a_lms_
alumna857343alumna
alums75720603alums_
ama510853303a__m_a
amas67746293a__mas
amia66836903a__mia
amias75831473amias_
amids85627513amids_
amidst94913233amidst
amies76837693amies_
amiga85514813ami_ga
amigas95912173amigas
amins75534323amins_
amirs75924923amirs_
amis66445323ami_s_
amiss75823073ami_ss
anemia82613573anemia
anhinga11104823anhinga
anils56326723anils_
animal85016253animal
anime75423203anim_e
animes84719593animes
animi74016663anim_i
animis84615943animis
animism113510213animism
animist93815173animist
animus84211613animus
anis45746463ani_s_
anise55129703ani_se
ansa45927773a__nsa
aphids125110843aphids_
aphis105917133aphi_s_
apish105116633api_sh
aria46245423ari__a
arias55438023arias_
arils58732203arils_
ariose64818723ariose
ariosi64313033ariosi
arioso64312403arioso
arise56436433ari_se
arista6415293arista
arms66137493a_rms_
aroma71220143arom_a
aromas81018613aromas
arums75517833arums_
ashiest10313953ashiest
athirst1037873athirst
atma68121773a_tm_a
atmas75721013a_tmas
atoms76817563atoms_
aviso85713963avi_so
axilla13289573axilla
axils127217503axils_
axioms15408053axioms_
axis116127913axi_s_
ayins85321613ayins_
bima86723833_bim_a
bimas95521743_bimas
brims94721623brims_
camisa103114323cami_sa
chamisa14328853chamisa
chams126028503chams_
chia96026623chi__a
chias104625523chias_
chiasm13449103chiasm
chiasma14366993chiasma
chica125818263chi_ca
chicas135916473chicas
chics123920943chics_
chimar133911473chimar
chimb144813563chim_b
chimbs153910303chimbs
chime125322593chim_e
chimed145814833chimed
chimer135517203chimer
chimera14389273chimera
chimes134922573chimes
chimlas1437453chimlas
chimp145216473chim_p
chimps155713663chimps
china105022483chi_na
chinas115119403chinas
chins105631463chins_
chips125721253chips_
chirms135113983chirms_
chis95933313chi_s_
chits105424573chits_
chrisma1456823chrisma
chums125015833chums_
crissa837623crissa
dims75435023_dims_
flimsy14345563flimsy
ghis85020163ghi_s_
glims87417673glims_
haems105517013haems_
haika125313793hai_ka
haiks125120933haiks_
hails85231643hails_
haimish1537753haimish
hairs86225173hairs_
hakims1537303hakims_
halma108219253halm_a
halmas117017893halmas
halms105225213halms_
hams96446133_hams_
hamza19139773_hamza
hansa85416783_hansa
harissa1035503harissa
harms106829013harms_
hems95534943_hems_
hies74842833_hies_
hijra1535643_hijra
hila76228353_hi_la
him86247663_him__
hins76447993_hins_
hips96433703_hips_
his66359503_hi_s_
hisn79620933_hi_sn
hiss75629213_hi_ss
hissy116112123_hissy
hist76551543_hi_st
hits75545133_hits_
hums96831423_hums_
kalimba1542663kalimba
khis117017983khi_s_
lima65734133_lim_a
limas75627633_limas
limba95414983_limba
limpa97014463_limpa
maims96321793maims_
marimba1354983marimba
maxima17568633maxim_a
maxims17399673maxims_
mimosa1036363_mimosa
nims66226883_nims_
ohia75719363ohi__a
ohias84415573ohias_
ohms95514033oh_ms_
oxims14107643oxims_
paisa76021073pai_sa
phis95724903phi_s_
pima85428653_pim_a
pimas94725103_pimas
prima95019343prim_a
primas104418103primas
prims95425933prims_
rhumba13375553rhumba
rims65936303_rims_
sahibs1137083sahibs_
shamas113717943shamas
shams105829413shams_
shicksa1634103shicksa
shies86136553shies_
shiest95821523shiest
shiksas1484643shiksas
shikse1386073shikse
shim95827863shim__
shimmy16306413shimmy
shins85131043shins_
ships105123773ships_
shist84829613shi_st
shits84731173shits_
shiva115915003shi_va
shivas124512413shivas
shivs115018803shivs_
sima64730783_sim_a
simas75727553_simas
sims65737173_sims_
skims114517193skims_
slims75423653slims_
slimsy11407723slimsy
swims105514143swims_
thins85826333thins_
thirst9312253thirst
this76027383thi_s_
trims75021473trims_
vims95423313_vims_
visa76323873_vi_sa
whams135515643whams_
whids125413983whids_
whigs125612643whigs_
whilst1239143whilst
whim126220533whim__
whimsey18373893whimsey
whins114922333whins_
whips134917083whips_
whipsaw1842723whipsaw
whirs115218093whirs_
whish144512923whi_sh
whisk154510143whi_sk
whist115322953whi_st
whits115923823whits_
whomso1434133whomso

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.1401276364.3
2DLD Change Limit1127162485.83019333.8
3Display Results2482480.0633936.5
 (SQL Overall)1786912486.03329618.9
 
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.