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 “tamarin” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

165 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
tamarin931192(None) 
tamari8313411tamari_
tamarind1147021tamarind
tamarins10310841tamarins
tamaris9413601tamaris
amain74922912_ama_in
cumarin1139262cumarin
savarin10310002savarin
taborin92210452taborin
talaria7412522talaria
tamarao977592tamarao
tamarau9107062tamarau
tamarinds1244162tamarinds
tamarisk1445472tamarisk
tamein8313092tam_ein
acari75020283_acari_
acarid95017073_acarid
acarine9316003_acarine
again65218123_aga_in
agaric93513643_agaric
alanin6317273_alanin
aldrin7311243_aldrin
amarna839793_amarna
amarone9311203_amarone
amazing1938813_amazing
amazon1736833_amazon
ambari103012173_ambari_
ambaris113112163_ambaris
amidin94015673_amidin
amin66042253_am__in
amorini9310353_amorini
amorino9310253_amorino
ataman81013063atama__n
atman75520143atma__n
attain6311753atta_in
atwain937813atwa_in
camail10314833cama_il
cambric1537393cambric
canakin131810833canakin
carabin11313213carabin
catamaran1344203catamaran
coumarin1247323coumarin
cumarins1238643cumarins
damaging1337393damaging
daman84821163dama__n
damar84117743damar__
damars93815003damar_s
domain9511323doma_in
etamin81311853etam__in
fumaric1446313fumaric
gamin84423003gam__in
gastrin839833gastrin
hadarim13117453hadarim
haematin13148893haematin
hamartia13115953hamartia
hematin121516023hematin
heparin12410433heparin
jalapin1645923jalapin
kamaaina1443273kamaaina
kamsin1238323kam_sin
laari54415713la_ari_
lambkin1545243lambkin
laminarin1146083laminarin
laminin939973laminin
main65345523__ma_in
malaria9313703malaria
malarian10311563malarian
manakin131810643manakin
mandarin11411023mandarin
margarin1148073margarin
margin94016853__margin
maria75032883__maria
marina84623413__marina
marine84230403__marine
marlin84220903__marlin
martin84122523__martin
matin75132853__matin
mavin105722953__mavin
mirin75023153__mirin
paladin101011773paladin
papain10313793papa_in
ptomain1146963ptoma_in
ramekin13126493ramekin
remain85919863rema_in
safari91110223safari_
safaris101110663safaris
samara8313853samar_a
samaras9312913samaras
samaritan1144183samaritan
samarium1257283samarium
sarin55239253__sarin
savarins1139893savarins
stearin7312003stearin
tabanid1047333tabanid
tabard9313333tabar_d
tabards10310383tabards
tabaret92717313tabaret
tabering112211423tabering
taborine102510683taborine
taboring113010193taboring
taborins103310223taborins
tacrine9311293ta_crine
tailfin1035693tailfin
tain45548073t__a_in
takin94921303t__akin
talapoin1045013talapoin
talar56225383talar__
talars66021683talar_s
tamable11312853tamable
tamal73522623tama__l
tamale83717403tama_le
tamales93216153tamales
tamals84116633tama_ls
tamandu1044433tamandu
tamarack1644363tamarack
tamaraos10105883tamaraos
tamaraus1096183tamaraus
tamarillo1152743tamarillo
tamarisks1543633tamarisks
tamasha12125433tamasha
tambourin1363623tambourin
tameins9311423tam_eins
tamer75230103tamer__
tamers84224033tamer_s
taming94023433tam__ing
tamis76728733tam__is
tammie104212693tam_mie
tampan102512323tam_pan
tampering1438453tampering
tamping122815813tam_ping
tampion11298663tampion
tampon102911233tam_pon
tannin62613933ta_nnin
tantric939593tantric
tapering112112503tapering
taring73932283t__aring
tarn46842723t__ar_n
tarring83318303ta_rring
tartaric1047063tartaric
tatami839193tatami_
tatamis939723tatamis
tatar56122063tatar__
tatars64619793tatar_s
taurine7311363ta_urine
tavern9428933taver_n
taxation1537993taxation
taxman15328613taxma__n
tearing84021493t_earing
terrain7410853terrain
thiamin1236933thiamin
thiazin1945483thiazin
timarau975853timarau
toman75724053toma__n
train56529113t_ra_in
triazin1638203triazin
trimaran1045643trimaran
tsarina736653t_sarina
tumbril11256403tumbril
twain86313623t_wa_in
tzarina1635053t_zarina
uakari1046863uakari_
uakaris1146633uakaris
warfarin1444983warfarin
zamarra1843793zamarra
zamarro1842883zamarro

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.410435831.7
2DLD Change Limit1340271657.09318895.7
3Display Results1651650.0602750.0
 (SQL Overall)1786911657.56323627.0
 
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.