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 “harijans” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
harijans184572(None) 
harijan1735781harijan_
habitans1346622habitans
hardpans1436452hardpans
hariana10310242hari_ana
harianas1139162hari_anas
harridans13154562harridans
parians93519732pari_ans
acaridans1254033acaridans
arias55438023_ari_a_s
artisans888523_artisans
avians93711563_avi_ans
banians9312033bani_ans
barbicans1544483barbicans
barchans1588683barchans
bartisans1165553bartisans
bartizans2053703bartizans
caimans113811783ca_imans
caravans1338623caravans
cardigans1345163cardigans
carinas93622413carina_s
caritas93316963carita_s
chairmans1685143chairmans
darshans1286543darshans
durians839573duri_ans
farinas103215243farina_s
gharials1245123ghari_als
habitan1236903habitan_
habitant1348673habitant
habitants1445123habitants
habitats1346733habitats
hairband1444573hairband
hairbands1544063hairbands
haircaps15144363haircaps
hairpins1365433hairpins
hanumans1344953hanumans
harass9313943har__ass
hardass1139753har_dass
hardens113815023har_dens
hardhats1546833hardhats
hardpan1336443hardpan_
haricots1347333haricots
haring104233003hari__ng
harissas1145983harissas
harkens144112863har_kens
harmins123716723har_mins
harpins123615703har_pins
harpoons1337483harpoons
harridan12145123harridan_
harshens1437603harshens
hartals10313023har_tals
hazans183411653ha__zans
hazzans18215783ha_zzans
hijabs1833083h__ijabs
horizons2045463horizons
jarinas143712193jarina_s
kalians11310183kali_ans
lariats7615053lari_ats
larrigans1044013larrigans
magians10310753magi_ans
marijuana1851663marijuana
marijuanas1951303marijuanas
marinas93519393marina_s
martians103111613martians
maryjane2043043maryjane
maryjanes2142993maryjanes
marzipans2242643marzipans
origans839973_origans
paisans93614753pa_isans
pariahs123812343pari_ahs
parian83223963pari_an_
partans94418283par_tans
partisans1167483partisans
partizans2055243partizans
puritans1037633puritans
radians83013823radi_ans
sarans64224433sar__ans
sarins63932623sari__ns
saurians837763sauri_ans
shaitans1136413sha_itans
shariahs14206393shari_ahs
sharias102516003shari_a_s
taipans9269553ta_ipans
tarpans92513533tar_pans
tartans72615823tar_tans
tarzans16329923tar_zans
therians1138313theri_ans
variant10316803vari_ant
variants1139203vari_ants
varias95019903vari_a_s
wanigans1244743wanigans
warisons1136903warisons
zaribas1836043zariba_s

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 Filter1786911461620.423422437.4
2DLD Change Limit146162936.45022660.8
3Display Results93930.0332818.2
 (SQL Overall)178691936.90625874.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.