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

82 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
sambhars154483(None) 
sambars115113841samb_ars
sambhar1444851sambhar_
sambhurs1543181sambhurs
sambals115213482samb_als
sambar103914162samb_ar_
sambas104219262samb_a_s
sambhur1453082sambhur_
samburs11369342samb_urs
samovars1343702samovars
abhors11410623_a_bhors
ambari103012173_amb_ari
ambaris113112163_amb_aris
ambary134010543_amb_ary
ambeers11428923_ambeers
ambers104519583_amb_ers
amblers115213563_amblers
cambers134017443camb_ers
camphors1737053camphors
damars93814993dam__ars
dammars12308193dam_mars
darbars10510093darb_ars
embars103812883_emb_ars
gambas115817513gamb_a_s
gambias125010733gambia_s
gambiers13337073gambiers
gambirs12359083gamb_irs
gamblers13369733gamblers
kabars124513953ka_b_ars
lahars94013163la__hars
lambdas1246243lambda_s
lambers113817113lamb_ers
lumbars11289763lumb_ars
mambas125716243mamb_a_s
mimbars1397383mimb_ars
ramblas112710263rambla_s
ramblers124010373ramblers
sabals84618863sa_b_als
sabbats1138633sa_bbats
sabers85224733sa_b_ers
sabirs85414633sa_b_irs
sabras85116363sa_bra_s
saggars93610683sa_ggars
samara8313853sam__ara
samaras9312913sam__aras
samba95618773samb_a__
sambaed1238303samb_aed
sambal105215183samb_a_l
sambos104315193samb__os
sambucas1444163sambucas
sambukes1644193sambukes
sambur10469503samb_ur_
samosas939293samosa_s
samovar1244243samovar_
sampans112411003sam_pans
samphire1545833samphire
samphires1645513samphires
samplers12299403samplers
samsara936913sam_sara
samsaras1045873sam_saras
samshus12125353samsh_us
samurais1046143samurais
sandbars11108783sandbars
sangars83116253sa_ngars
sansars73313913sa_nsars
sardars83112903sa_rdars
sarsars73512143sa_rsars
sashays1336333sa_shays
semihard1444673semihard
seminars1079043seminars
shmears1277073shm_ears
shophars1646353shophars
simars84916933sim__ars
simitars1046483simitars
simulars1047073simulars
smashers13339593smashers
smears84714433s_m_ears
tambacs13219363tamb_acs
tambaks15218153tamb_aks
tambours1255873tambours
tamburas12316053tamburas
tamburs11288613tamb_urs

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.1531167915.0
2DLD Change Limit146162826.76621602.4
3Display Results82820.0332484.8
 (SQL Overall)178691826.95225703.5
 
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.