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

361 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
tanrecs93482(None) 
tanrec837801tanrec_
tenrecs936031tenrecs
tandems1037632tandems
tankers113416912tankers
tanners74018392tanners
tares57456562ta_re_s
tarocs84615662ta_rocs
tarres64723042tarre_s
tenrec837512tenrec_
acres76327763_acre_s
agrees74915323_agrees
airers64922313_airers
alecs76620733_a_lecs
ancress978613_ancress
anes45255933_an_e_s
angels74416173_angels
angers75222543_angers
antes56334323_ante_s
antics84621453_antics
antres65021003_antre_s
apres75426403_apre_s
arcs67834783_a_r_cs
areas55935773_a_reas
areca75618633_a_reca
arecas84817443_a_recas
ares45871023_a_re_s
aures55137093_aure_s
aureus65314883_aureus
banders104324563banders
banes74945583ban_e_s
bangers104020353bangers
bankers133919093bankers
banners94018713banners
bannets94013843bannets
banters94623113banters
bares75457133ba_re_s
barneys12569563barneys
barrels94514363barrels
barrens94414323barrens
barres84427543barre_s
barrets94917103barrets
cadres94017933cadre_s
cancels114113313cancels
cancers114018583cancers
caners84629203can_ers
canes75350373can_e_s
cankers134418753cankers
cannels93413363cannels
canners93822663canners
canoers94318373canoers
canoes84725883canoe_s
canters94827733canters
carers85133963ca_rers
cares77369183ca_re_s
caress85720263ca_ress
carets85330773ca_rets
carnets93918403carnets
carneys124310543carneys
carrels95117303carrels
dancers103413093dancers
dances95120653dance_s
danders93921183danders
dangers94818213dangers
darers75921873da_rers
dares66146703da_re_s
darics94314113da_rics
darnels83710433darnels
darners83815773darners
eagres74014573eagre_s
earners74016453earners
fabrics1436093fabrics
fanes84639893fan_e_s
fanfics1535173fanfics
fanjets1734803fanjets
fanners103914653fanners
farces115223323fa_rces
farers95924053fa_rers
fares85852873fa_re_s
farness102912203farness
fennecs12305693fennecs
ganders93521703ganders
ganefs10489203gan_efs
ganevs10456913gan_evs
gangers94418603gangers
gangrels1094973gangrels
gannets83811443gannets
garners83815983garners
garnets84115403garnets
garrets84413623garrets
genres75515623genre_s
haeres94017033haere_s
hances115621283hance_s
handers114224333handers
hangers113120813hangers
hankers144218133hankers
hansels104011653hansels
hanses95022633hanse_s
harems115513823ha_rems
hares86255543ha_re_s
harness102413933harness
hatreds11307813hatreds
janes124928123jan_e_s
kanes95529373kan_e_s
labrets939363labrets
lancers93616643lancers
lances84824103lance_s
lancets93411163lancets
landers84026213landers
lanes54946793lan_e_s
langrels9106173langrels
lanners73618333lanners
larees65323113la_rees
lares54852633la_re_s
laurels746663laurels
madres93718183madre_s
mandrels1137313mandrels
manes76648963man_e_s
mangels103614493mangels
mangers103521263mangers
manges94628943mange_s
maniacs114313063maniacs
manics103919933man_ics
maniocs113611443maniocs
manless93012933manless
manners93417833manners
manses84225513manse_s
mantels94515043mantels
mantes84430783mante_s
manurers1037593manurers
manures9313353manure_s
marcs95726623ma_r_cs
mares76457633ma_re_s
marrers93414313marrers
matres84522233matre_s
nacres85614453nacre_s
nances83618643nance_s
narcs76122023na_r_cs
nares55544153na_re_s
padres95016983padre_s
pancreas1235393pancreas
pandect12310953pandect
pandects1335843pandects
panders103423733panders
panels84716523pan_els
panes76148693pan_e_s
pangens103112063pangens
panics103815363pan_ics
paniers94717333paniers
panners93621273panners
pannes85522853panne_s
panzers184012013panzers
pareos87023773pa_reos
parers85530743pa_rers
pares77164483pa_re_s
pareus85420743pa_reus
parrels94713493parrels
parsecs11429923parsecs
rances84625443rance_s
ranees64623963ran_ees
rangers83621043rangers
ranges73826923range_s
rankers113217463rankers
ranters73323643ranters
rares55247443ra_re_s
recs65734183___recs
sabres85520863sabre_s
sanders84025943sanders
sanes55649073san_e_s
sangers84421943sangers
sanies63031953sanie_s
sanseis73011603sanseis
sarees65329943sa_rees
saurels749303saurels
snarers74216663snarers
snares65329033snare_s
stances93715963stance_s
standees93310143standees
standers93514303standers
stanes64933403stan_e_s
starers74522313sta_rers
stares66038753sta_re_s
starets73515923sta_rets
tabarets10287233tabarets
tabers84621573ta_bers
tabes76033923ta_be_s
tables84524883table_s
tablets94714373tablets
taborers10268333taborers
taborets10278063taborets
taces76237803ta_ce_s
taches114224173tache_s
tackers134319623tackers
tackets134914363tackets
tactics1149323tactics
taels56822073ta__els
taggers93514193taggers
tagrags936123tagrags
tahrs85412333tahr__s
tailers73720183tailers
tajes124920693ta_je_s
takers103923743ta_kers
takes94437793ta_ke_s
talcs74817183ta__lcs
talers64628143ta_lers
tales55451373ta_le_s
talkers113513213talkers
tambacs13219363tambacs
tamers84224033ta_mers
tames75242013ta_me_s
tampers113516743tampers
tanagers9259003tanagers
tandem9311403tande_m
tanged84622493tange_d
tangelo837033tangelo
tangelos935743tangelos
tangence1146703tangence
tangences1246443tangences
tangency1444563tangency
tangent8314993tangent
tangents938713tangents
tanglers92911973tanglers
tangles83920043tangles
tangos74216303tan_gos
tangrams1136163tangrams
tangs65028343tan__gs
tanists7313653tanists
tankas104613763tan_kas
tanked113919293tanke_d
tanker104521123tanke_r
tankless12267823tankless
tanks94624733tan__ks
tanned75219953tanne_d
tanner63722283tanne_r
tannery10388663tannery
tannest72617853tannest
tannic82811473tannic_
tannins72813223tannins
tannoys1055553tannoys
tans46154823tan___s
tansies74521243tansies
tantras73112093tantras
tantric939583tantric_
tantrums1045113tantrums
tanukis1134713tanukis
taperers10269773taperers
tapers84025813ta_pers
tapes75838603ta_pe_s
tappers113416543tappers
tappets113610013tappets
tare45957623ta_re__
tared69340053ta_re_d
targes74524593ta_rges
targets84314223targets
tarmacs1138323tarmacs
tarns56433953ta_r_ns
taroc75721643ta_roc_
taroks106115283ta_roks
taros55640823ta_r_os
tarots66422993ta_rots
tarps76527113ta_r_ps
tarre55825633tarre__
tarred74720283tarre_d
tarriers83411713tarriers
tarries73324263tarries
tars46763953ta_r__s
tarsus6310513ta_rsus
tarts57242023ta_r_ts
tassels74510853tassels
tasses64826763tasse_s
tassets75012773tassets
tasters74225643tasters
tastes64126423taste_s
taters64932203ta_ters
tates55444983ta_te_s
tatters74520483tatters
taunters8259273taunters
taupes8212673taupe_s
tautens7317843tautens
taverns10317803taverns
tawers94118603ta_wers
tawneys13324773tawneys
tawnies102812503tawnie_s
tawses94913193tawse_s
taxers134015283ta_xers
taxes124730823ta_xe_s
taxies135817333taxie_s
taxless1436903taxless
tearers75218233tearers
tenaces92814513tenaces
tenders83719723tenders
tenets65518953ten_ets
tenners74014923tenners
tenses64722553tense_s
tenters73921103tenters
tenues63816443tenue_s
tenures7412013tenure_s
terces83921413t_erces
ternes65422903terne_s
terrets72913583terrets
thanes94918983than_e_s
thankers15297833thankers
theres96525473there_s
threes97117323t_hrees
tierces93710453tierces
tigress836093tigress
tinders84219173tinders
tineas64616483tin_eas
tines54848423tin_e_s
tinges74722333tinge_s
tinkers113517143tinkers
tinners73717313tinners
tinsels738373tinsels
tinters74221113tinters
tires55437493t_ire_s
titres64718933titre_s
toners64128003ton_ers
tones56048663ton_e_s
tongers84116013tongers
tonics83617863ton_ics
tonlets73212503tonlets
tonners73816403tonners
tonnes65320853tonne_s
torcs75123763t_or_cs
tores55352673t_ore_s
torics85118353t_orics
tourers73512743tourers
trances93919643trance_s
transect10410053transect
transects1157823transects
trees55835763t__rees
treks96016853t__reks
tres46542903t__re_s
tress55423163t__ress
trets55928023t__rets
trews86118893t__rews
treys85018213t__reys
tsores65113663tsore_s
tuners64417343tun_ers
tunes55332193tun_e_s
tunics83811263tun_ics
tunnels7328723tunnels
turners73912893turners
turrets73010673turrets
twangers12226063twangers
tynes85920303tyn_e_s
tyres84725233t_yre_s
vanes85130973van_e_s
vanners103612843vanners
wanders114221333wanders
wanes85040883wan_e_s
wankers144514713wankers
wanness102610683wanness
wanters104420093wanters
wares88250583wa_re_s
warners103315563warners
warrens103810893warrens
yarners104312203yarners
zaires1539703zaire_s
zanders173015793zanders
zanies153219673zanie_s

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 Limit1340273617.68617437.8
3Display Results3613610.1262865.1
 (SQL Overall)1786913617.96822426.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.