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

67 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
sambhur145308(None) 
sambhar1444851sambhar
sambhurs1543181sambhurs
sambur10469501samb_ur
sambar103914162samb_ar
sambhars1544832sambhars
samburs11369342samb_urs
samshu11134622samshu_
samshus12125352samshus
tambour1136352tambour
tambur10358712tamb_ur
abhor10411063_a_bhor
ambeer104511603_ambeer
amber94523213_amb_er
ambler104916453_ambler
amour75014853_am_our
arbour84211333_arbour
camber124418483camb_er
cambium1537323cambium
camphor1636133camphor
gambier124711973gambier
gambir11509773gamb_ir
gambler123612683gambler
hamburg1544123hamb_urg
harbour1247053harbour
iambus10468903iamb_us
labour84210933la_bour
lamber104418493lamb_er
lambier113611643lambier
mohur1036513__mohur
rambler113313263rambler
saber75330243sa_b_er
sabir75917003sa_b_ir
sacbut10811943sacb_ut
saddhu1133413saddhu_
saddhus1243673saddhus
sadhu9459963sa_dhu_
sadhus10298463sa_dhus
sagbut959753sagb_ut
samba95618773samb__a
sambaed1238303sambaed
sambal105215183samb_al
sambals115213483sambals
sambars115113843sambars
sambas104219263samb_as
sambo95118013samb__o
sambos104315193samb_os
sambuca1344343sambuca
sambuke1544203sambuke
samovar1244243samovar
samphire1545833samphire
sampler113212013sampler
sandbur10105353sandbur
santour737373santour
santur6311273sa_ntur
sapour83812373sa_pour
saviour1035213saviour
savour94110703sa_vour
smasher123911023smasher
smashup1443453smashup
somber103714003somb_er
sulphur12123873sulphur
tabour84011323ta_bour
tamboura1253893tamboura
tambours1255873tambours
tambura11326463tamb_ura
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 Filter1786911340270.390458182.1
2DLD Change Limit134027676.19021652.2
3Display Results67670.0302233.3
 (SQL Overall)178691676.61027033.4
 
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.