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

261 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
takahes143617(None) 
takahe1335791takahe_
taches114224172ta_ches
takas95520682taka__s
takes94437792tak__es
tamales93216152tamales
tankages13217112tankages
wakames1635282wakames
aahed917816443_a_ahed
aahs716428563_a_ah_s
abases85720773_abases
abashes12510373_abashes
abates85825033_abates
aches106132293_a_ches
adages8412953_adages
agapes95212413_agapes
agates76121343_agates
agaves104611513_agaves
akees96119243_ak_ees
akenes104817343_akenes
alates64833963_alates
alkahest1554023alkahest
alkanes113812933alkanes
amahs107819063_amah_s
amazes175613473_amazes
apaches143411833_apaches
arames84622573_arames
arches114822043_arches
ashes86230613_a_shes
atlases72410643atlases
attaches13137723attaches
awakes135012473_awakes
ayahs116813523_ayah_s
baases85218013ba_ases
baches135426943ba_ches
backaches22146813backaches
bakes117035373bak__es
balases93815433balases
bashes115631393ba_shes
batches144019613batches
bathes116524833ba_thes
caches137926913ca_ches
cakes116037673cak__es
calashes13310533calashes
camases114216343camases
canapes111213083canapes
carafes125015703carafes
carates95630613carates
cashes114729883ca_shes
catches144320773catches
damages11511273damages
dashes106124983da_shes
dekares122710873dekares
earaches13411303earaches
facades1339033facades
fakes126032483fak__es
fashes124524023fa_shes
galahs105512673galah_s
galaxes1538873galaxes
gamashes1456943gamashes
ganaches1437413ganaches
garages9314113garages
gashes105725153ga_shes
gavages1237683gavages
hakes126034303hak__es
hamates122917683hamates
hapaxes1936593hapaxes
hashes125024803ha_shes
hatches153420273hatches
jacales16310323jacales
jakes165023643jak__es
kaes85734063__ka_es
kakapos1243673kakapos
kakas85117343kaka__s
kales95730983__kales
kames115024693__kames
kanes95529373__kanes
karates115617473karates
laches116528343la_ches
lakes95737653lak__es
lakhs125210343lak_h_s
larches124416443larches
lashes94831003la_shes
latches123320123latches
lathes95127493la_thes
lavages1138603lavages
lavashes1445573lavashes
leakages1334933leakages
maches134827233ma_ches
madames12310063madames
makars124612633maka_rs
makes115336853mak__es
malates93522603malates
manages103418963manages
manches143818623manches
marches143921173marches
marshes123615373marshes
mashes115030003ma_shes
matches143219783matches
naches114622413na_ches
naiades838213naiades
packages17138733packages
pakehas1635313pakehas
palaces114216453palaces
palates93624933palates
panaches15310283panaches
parades104121463parades
parches143720003parches
parkades1538273parkades
pashes115828393pa_shes
patches143320383patches
pavanes123612653pavanes
pikakes1245823pikakes
rajahs16497663rajah_s
rakees104516973rak_ees
rakes94440353rak__es
ranches123620113ranches
raphes115117453ra_phes
rashes95330153ra_shes
ratches123620463ratches
ravages1139403ravages
rayahs12579193rayah_s
sadhes104715373sa_dhes
sakes95540753sak__es
sarapes94617743sarapes
sashes94728483sa_shes
savages1139973savages
savates10312953savates
skates104219403_skates
soakages1336143soakages
staithes1138953staithes
stakes103927293stak__es
stanches132312793stanches
starches131912913starches
stashes103916173sta_shes
tabards10310383tabards
tabaret92717313tabaret
tabarets10287233tabarets
tabbies112913503tabbies
tabes76033923t__abes
tables84524893ta_bles
taces76237803t__aces
tache106222373ta_che_
tachs105820933ta_ch_s
tackles133816523tackles
taffies133012693taffies
tahrs85412333t__ahrs
tailles72516473tailles
tajes124920693t__ajes
taka87623593taka___
takable13310193takable
take84739263tak__e_
taken94819143tak__en
taker95229003tak__er
takers103923743tak_ers
takeups1333403takeups
takings124512573takings
takins105117403tak_ins
talars66021683tala_rs
talas55935893tala__s
tales55451373t__ales
talipes9611603talipes
talkies113415733talkies
tallages92312003tallages
tallies73624603tallies
taluses7311213taluses
tamale83717403tamale_
tamals84116633tama_ls
tamaris9413593tamaris
tamashas13135683tamashas
tames75242013t__ames
tamises92715973tamises
tammies113814683tammies
tanager83010943tanager
tanagers9259003tanagers
tangles83920043tangles
tankage12257773tankage_
tankards1366253tankards
tankas104613763tanka__s
tannages9228963tannages
tannates81911953tannates
tansies74521243tansies
tapalos938813tapalos
tapas74627713tapa__s
tapes75838603t__apes
tapises92914013tapises
taramas9612703taramas
tardies84225863tardies
tares57456563t__ares
targes74524593ta_rges
tarres64723043ta_rres
tarries73324263tarries
tasses64826763ta_sses
tassies74918933tassies
tastes64126423ta_stes
tatamis939723tatamis
tatars64619793tata_rs
tates55444983t__ates
tatties74120343tatties
tattles73616283tattles
taupes8212673ta_upes
tawnies102812503tawnies
tawpies12309873tawpies
tawses94913193ta_wses
taxables1734383taxables
taxemes1635853taxemes
taxes124730823t__axes
taxies135817333ta_xies
taxites1449673taxites
teacakes1435883teacakes
teaches122718353teaches
teases65426273t_eases
teawares1148083teawares
teethes103611653teethes
tekkies1035943tekkies
tenaces92814513tenaces
tenches123515523tenches
texases1437573texases
thanages12107623thanages
thanes94918983t_hanes
thatches1637513thatches
thrashes1487653thrashes
thraves13469713thraves
tikes95628903tik__es
tirades8311723tirades
tisanes7311853tisanes
tithes94720213t_ithes
tokays13397773toka_ys
tokes95234973tok__es
tolanes74216313tolanes
topazes1857313topazes
tophes115218423t_ophes
torahs95115643torah_s
torches123715433torches
toshes94520103t_oshes
touches125118343touches
towages1139233towages
traces85329933t_races
trackages1645343trackages
trades75724503t_rades
tranches132915513tranches
trapes85024463t_rapes
trashes104119263trashes
traves94222743t_raves
triages82613793triages
troches123715343troches
tsades74310993t_sades
tuckahoes1842273tuckahoes
tusches1237903tusches
tushes94319473t_ushes
twaes86513663t_wa_es
tykes125817063tyk__es
tythes12419703t_ythes
uakaris1146633uakaris
ukases10358063_ukases
vacates12312833vacates
wakame1535433wakame_
wakes126633653wak__es
washes124425493wa_shes
watapes12228383watapes
watches153017373watches

Search took 7 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.390458182.1
2DLD Change Limit1340272616.05022153.2
3Display Results2612610.0932806.5
 (SQL Overall)1786912616.53327352.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.