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

168 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
tankard126726(None) 
tankards1366251tankards
tanyard1167181tanyard
bankcard1774022bankcard
canard9314762can_ard
laniard868522laniard
lanyard1167292lanyard
mansard1049312mansard
manward1349092manward
standard1046252standard
stinkard1344322stinkard
tabard9313332ta_bard
tanbark1337372tanbark
tanka93817482tanka__
tankage12257772tankage
tankas104613762tanka_s
tanked113919292tank_ed
tanker104521122tanker_
tankers113416912tankers
tantara72410812tantara
tanyards1276182tanyards
vanward1456942vanward
aboard9312613_aboard
afeard1058263_afeard
anear55420323_anear_
aneared8512743_aneared
anears63717183_anears
angary10311323_angary
ankled114313473_ankled
award97118043_a_ward
awkward1843183_awkward
backward2048103backward
backyard2046843backyard
bandaid11310473bandaid
bankcards1873783bankcards
banked135021443bank_ed
banker124222733banker_
bankers133919093bankers
barnyard1443783barnyard
bastard103012423bastard
bayard124411663ba_yard
blinkard1543043blinkard
canards10311203can_ards
canary11314693can_ary
canker124422523canker_
cankered153010223cankered
cankers134418753cankers
danker114319663danker_
dastard9279703dastard
drunkard1441553drunkard
fanfare1336673fanfare
flancard1443373flancard
gabbard1336553gabbard
haggard13377183haggard
halyard1476973halyard
hangar104114503hangar_
hangared1337563hangared
hangars114313483hangars
hanked144220603hank_ed
hanker134622093hanker_
hankered16289443hankered
hankers144218133hankers
hayward1736413hayward
hazard1938403ha_zard
inward10310333_inward
junkyard2341753junkyard
kantar10311153kantar_
kantars11310033kantars
laggard10347623laggard
landward1345823landward
laniards967313laniards
laniary1068013laniary
lanker104123003lanker_
lanyards1266393lanyards
makar115614973ma_kar_
makars124612633ma_kars
mallard10310273mallard
mankind1437773mankind
mansards1148013mansards
manuary1237773manuary
manwards1447613manwards
mazard1838763ma_zard
mazzard1844463mazzard
nard56634453__n_ard
onward1039053_onward
poniard1037583poniard
ranked114620743rank_ed
ranker105021903ranker_
rankers113217463rankers
rankled123910653rankled
saggard10358953saggard
sangar73617683sangar_
sangars83116253sangars
sansar63613393sansar_
sansars73313913sansars
staggard1144513staggard
standards1145203standards
stannary1144613stannary
stanzaed1843873stanzaed
stinkards1443553stinkards
sunward1137653sunward
tabards10310383ta_bards
tackboard1844723tackboard
tacked134723943tack_ed
tacker124224503tacker_
tackers134319623tackers
tackled143913183tackled
tagboard1245563tagboard
taka87623593ta_ka__
takahe1335793ta_kahe
takas95520683ta_ka_s
taker95229003ta_ker_
takers103923743ta_kers
talar56225383ta_lar_
talars66021683ta_lars
talked114015403talk_ed
talker103916223talker_
talkers113513213talkers
tamari8313383ta_mari
tanbarks1445563tanbarks
tanga64923683tanga__
tanged84622493tan_ged
tangled94214633tangled
tangoed9318833tangoed
tangram1038063tangram
tank85134013tank___
tankages13217113tankages
tankful1445153tankful
tanking123918793tanking
tankini11338923tankini
tanks94624733tank__s
tannage8209583tannage
tannate71813523tannate
tanned75219953tan_ned
tanner63722283tanner_
tanners74018393tanners
tannery10388653tannery
tantaras8269533tantaras
tantra63713353tan_tra
tantras73112093tantras
tartar63214753tartar_
tartare73012683tartare
tartars73313403tartars
taskbar1393023taskbar_
taskbars1452983taskbars
tasked114714643task_ed
tatar56122063ta_tar_
tatars64619793ta_tars
taxpaid1743093taxpaid
teaboard1146293teaboard
thanked15469153thank_ed
thanker14309593thanker_
thankers15297833thankers
tinker103619923tinker_
tinkered1387683tinkered
tinkers113517143tinkers
tinkled123910473tinkled
tinware1038593tinware
tonearm937443tonearm
toward10311063t_oward
uakari1046863ua_kari
vanguard1343893vanguard
vaward13498723va_ward
wanked144517153wank_ed
wanker134219973wanker_
wankers144514713wankers
wayward1736053wayward
yanked144312243yank_ed

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.1561145455.1
2DLD Change Limit1340271688.11016526.1
3Display Results1681680.0632666.7
 (SQL Overall)1786911688.32921454.1
 
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.