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

78 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
samovar124424(None) 
samovars1343701samovars
sambar103914162sam_bar
sambhar1444852sambhar
samosa8510202samosa_
samosas939292samosas
serovar1046142serovar
amoral8314623_amoral
amour75014853_amo_ur
camorra11115763camorra
damar84117733dam__ar
dammar11438903dam_mar
hamular1236973hamular
laminar93810283laminar
layover1334433layover
molar75223093__molar
mover104220863__mover
navar83912733na__var
osmolar944483osmolar
ramona8412413ramona_
ramonas9311093ramonas
removal1236733removal
remover124612273remover
saggar84010853sa_ggar
saliva93110743saliva_
salivary1444733salivary
salivas10309603salivas
salver94617753sa_lver
salvor94711093sa_lvor
samara8313853sam__ara
samaras9312913samaras
samba95618773sam_ba_
sambal105215183sam_bal
sambars115113843sam_bars
sambas104219263sam_bas
sambhars1544833sambhars
sambhur1453083sambhur
sambur10469503sam_bur
samoyed1335893samoyed
sampan102511893sam_pan
sampler113212013sampler
samsara936913sam_sara
samurai945923samurai
sandbar10108193sandbar
sangar73617683sa_ngar
sansar63613393sa_nsar
sapor75119253sapo__r
sapota8310203sapota_
sapotas939603sapotas
sapour83812373sapo_ur
sardar73013173sa_rdar
sarsar63011843sa_rsar
saver84831253sa__ver
savor85417943sa__vor
savorer1057883savorer
savour94110703savo_ur
sayonara1142593sayonara
scholar1236943scholar
seminar979753seminar
semioval1346223semioval
serovars1145233serovars
shmear1176933shm_ear
shofar1236303s_hofar
shover124515983s_hover
simar74920813sim__ar
similar937853similar
simitar936733simitar
simular938673simular
smear74416393s_m_ear
smoker124311693s_moker
soar46838673s__o_ar
sofar86115493s__ofar
solar55927343s__olar
sonar56523423s__onar
sowar85821343s__owar
stover94115643s_tover
suboval12216723suboval
valvar12388653va_lvar

Search took 8 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.1561145455.1
2DLD Change Limit134027787.03319056.9
3Display Results78780.0302600.0
 (SQL Overall)178691787.21924752.9
 
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.