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

91 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
samurai94593(None) 
samurais1046151samurais
samara8313852samara_
samaras9312912samaras
ambari103012173_ambari
amoral8314633_amoral
amtrac10109133_amtrac
amusia839173_amusia
anural65714743_anural
anuran64313243_anuran
anuria6313123_anuria
aura45836253_a_ura_
aurae54128113_a_urae
aural54428963_a_ural
aurar54420253_a_urar
auras55932563_a_uras
aurei54821863_a_urei
camera10313693camera_
camerae11312063camerae
cameral11311283cameral
cameras11313363cameras
datura738033datura_
daturas838783daturas
famuli1136763famu_li
hamular1236973hamular
hamuli1137063hamu_li
kauri93811853ka_ur_i
laura54116203la_ura_
laurae64011663la_urae
lauras63414333la_uras
mura65633303__mura_
mural75225113__mural
muras75329583__muras
natural739513natural
parura8310583parura_
paruras9310533paruras
sabra75317853sa_bra_
sabras85116363sa_bras
sacra74516993sa_cra_
sacral83414413sa_cral
safari91110223safar_i
saguaro845513saguaro
sahuaro1044233sahuaro
saluki1036203salu_ki
samadhi1344063samadhi
samba95618773sam_ba_
sambal105215183sam_bal
sambar103914163sam_bar
sambars115113843sambars
sambas104219263sam_bas
sambhar1444853sambhar
sambuca1344343sambuca_
sambucas1444163sambucas
sambur10469503sambur__
samburs11369343sambur_s
samosa8510203samosa_
samosas939293samosas
samovar1244243samovar
sampan102511893sam_pan
samsara936913samsara
samsaras1045873samsaras
sangria838113sangria
saran53730303sa__ran
sari45444043sa__r_i
satara6315533satara_
sataras7315063sataras
satori6415843sator_i
satrap86212553sa_trap
saturant8410643saturant
saturate8312813saturate
sauna54117553sa_una_
saunas63915433sa_unas
saurel6511993sa_urel
saurian739913sa_urian
saury84317223sa_ur_y
semiraw1246053semiraw
serai56830163s__erai
simular938673simular
souari6311383s_ouari
sura45740293s__ura_
surah86823253s__urah
sural55931263s__ural
suras55336333s__uras
sutural7310223sutural
synura935983synura_
synurae1044253synurae
tamarao977593tamarao
tamarau9107063tamarau
tamari8313413tamar_i
tambura11326463tambura_
tamburas12316053tamburas

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.406440125.6
2DLD Change Limit134027917.00019146.7
3Display Results91910.0303033.3
 (SQL Overall)178691917.43624030.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.