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

175 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
tinware103860(None) 
tinwares1137911tinwares
infare9313082_infare
inward10310332_inward
pinwale1257842pinwale
teaware1048142teaware
tinwork1476992tinwork
zingare1737142zingare
airfare1047243airfare
airward1148133airward
airwave1344433airwave
aware86420023__aware
barware12610703barware
beware11313713_beware
binary11312223bin_ary
binate8419773bin_ate
caneware1347803caneware
centare93113703centare
chinaware1752973chinaware
dinar66319893din_ar_
dinars75417563din_ars
dishware1545433dishware
fanfare1336673fanfare
finale94116763fin_ale
finmark16154883finmark
firmware1643963firmware
giftware1542463giftware
gunwale1134733gunwale
inane52820343_in_ane
inarm7314423_in_arm
incage93513623_incage
incase83615283_incase
infares10313023_infares
ingate73018243_ingate
inhale9411523_inhale
inhere9313713_inhere
injure133410863_injure
inlace82513043_inlace
inmate82917363_inmate
innage73011573_innage
innate63917313_innate
insane6314893_insane
insnare748243_insnare
insure63416603_insure
intake10510863_intake
inure54119053_in_ure
invade10157853_invade
invar839513_invar_
invars9310003_invars
inwall938343_inwall
inwards1138343_inwards
inweave1344723_inweave
inwove12167273_inwove
inwrap11115903_inwrap
ironware1144653ironware
kinara10310373kin_ara
kinase104210653kin_ase
linage7713403lin_age
lindane839033lindane
lineage878983lineage
linear65113343linear_
lineate7815153lineate
linkage1295963linkage
manward1349093manward
minae75627723min_a_e
minaret9520683min_aret
mintage101110123mintage
nonwage1137163nonwage
nonwar9159423nonwar_
nonwars10109003nonwars
onward1039053_onward
ovenware1444243ovenware
pinnace113510313pinnace
pinnae84414643pinna_e
pinnate93613743pinnate
pinwales1367963pinwales
pinwork16107243pinwork
pinworm1467183pinworm
qindar16317173qindar_
qindars17267423qindars
qintar15359143qintar_
qintars16268573qintars
redware1139363redware
seaware1049633seaware
sincere9310553sincere
sinkage1287263sinkage
sinuate7412163sinuate
slipware1344543slipware
snare54429983_sn_are
stemware1344883stemware
stingaree1044473stingaree
stinkard1344323stinkard
stoneware1254293stoneware
sunward1137653sunward
sware85828213__sware
tanbark1337373tanbark
tankage12257773tankage
tankard1267263tankard
tannage8209583tannage
tannate71813523tannate
tantara72410823tantara
tanyard1167183tanyard
tare45957623t___are
tartare73012683tartare
teawares1148083teawares
tenace82715693ten_ace
teniae64517353tenia_e
tentage81010643tentage
tenure6311613ten_ure
thwart12311683t_hwart
tiara5315913ti__ara
tibiae838483tibia_e
tillage83111343tillage
timbale11248803timbale
timbre10328633ti_mbre
tincal83913373tinca_l
tincals93610653tincals
tincture1044683tincture
tinder73821803tinder_
tinders84219173tinders
tindery11389363tindery
tine45855143tin___e
tinea54923163tinea__
tineal66216173tinea_l
tineas64616483tinea_s
tinge64626633tin__ge
tingle74319073tin_gle
tingler83613343tingler
tinhorn1046033tinhorn
tinier63622233tinier_
tinker103619923tinker_
tinkered1387683tinkered
tinkerer1286803tinkerer
tinkers113517143tinkers
tinkle103714453tin_kle
tinkler113610543tinkler
tinlike11248803tinlike
tinman82411143tinma_n
tinner64119963tinner_
tinners73717313tinners
tinnier72910143tinnier
tinplate1047743tinplate
tinter63923643tinter_
tinters74221113tinters
tintype1243033tintype
tinworks1596043tinworks
tipcart1148833tipcart
tirade7311693ti_rade
tire46143363ti___re
tisane6311573ti_sane
titlark1144723titlark
titrate72215583titrate
titre54619393ti__tre
tonearm937443tonearm
tonnage8168053tonnage
tonsure758783tonsure
towage1039833t_owage
toward10311063t_oward
treenware1243783treenware
trinary1039173trin_ary
tripwire1343603tripwire
tunnage8166373tunnage
twae74719573t__wa_e
unaware1038033unaware
unwary1239823_unwary
vanward1456943vanward
vintage11128143vintage
ware76254723___ware
wetware1335803wetware
windage1237933windage
windward1665513windward
zincate1838533zincate
zingara1745513zingara
zingari1745483zingari
zingaro1745123zingaro

Search took 9 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.436409841.7
2DLD Change Limit1340271758.37616001.3
3Display Results1751750.0632777.8
 (SQL Overall)1786911758.87520134.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.