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

94 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
tamarao97759(None) 
tamaraos10105881tamaraos
tamarau9107061tamarau
samara8313852samara_
samaras9312912samaras
tamarack1644362tamarack
tamaraus1096182tamaraus
tamari8313402tamar_i
tamarin9311912tamarin
tamaris9413592tamaris
timarau975852timarau
zamarro1842882zamarro
amarna839793_amarna
amoral8314633_amoral
amtrac10109123_amtrac
atamasco1242333atamasco
bacalao1146613bacalao
camera10313693camera_
camerae11312063camerae
cameral11311283cameral
cameras11313363cameras
carabao1139673carabao
catamaran1344203catamaran
damar84117733damar__
damars93814993damar_s
hamada1239923hamada_
hamadas1339673hamadas
kamala12339963kamala_
kamalas13339123kamalas
labara83712893labara_
mara67444573__mara_
maras75443293__maras
ramada9310183ramada_
ramadas1039303ramadas
samsara936913samsara_
samsaras1045873samsaras
samurai945923samurai
satara6315533satara_
sataras7315063sataras
tabard9313333tabar_d
tabards10310383tabards
tabaret92717313tabaret
tagrag837043ta_grag
talar56225383talar__
talaria7412513talaria
talars66021683talar_s
tamable11312853tamable
tamal73522623tam__al
tamale83717403tama_le
tamales93216153tamales
tamals84116633tama_ls
tamandu1044433tamandu
tamaracks1743753tamaracks
tamarillo1152743tamarillo
tamarind1147023tamarind
tamarins10310843tamarins
tamarisk1445473tamarisk
tamasha12125433tamasha
tamashas13135683tamashas
tambac122210243tam_bac
tambak14249263tam_bak
tambala1138023tambala_
tambalas1237033tambalas
tambura11326463tambura_
tamburas12316053tamburas
tamer75230103tamer__
tamers84224033tamer_s
tampala1136613tampala_
tampalas1245473tampalas
tampan102512323tam_pan
tangram1038073tangram
tantara72410823tantara_
tantaras8269543tantaras
tantra63713353tantra_
tantras73112093tantras
tapalo839793tapa_lo
tarama8412733tarama_
taramas9612703taramas
tardo65321103t__ardo
taro46846913t__ar_o
tatar56122063tatar__
tatars64619793tatar_s
tiara5315913t_iara_
tiaras6314553t_iaras
timaraus1095073timaraus
timbral11237193timbral
tomato8313453toma_to
trimaran1045643trimaran
tuatara745513tuatara_
tuataras844863tuataras
tumoral938133tumoral
zamarra1843783zamarra
zamarras1943803zamarras
zamarros1942683zamarros

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 Limit134027946.73619897.1
3Display Results94940.0303133.3
 (SQL Overall)178691947.17224915.1
 
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.