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

385 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
tarsiers829853(None) 
tarriers83411711tarriers
tarsier74119251tarsier_
barriers104311882barriers
brasiers103710512brasiers
carriers103614202carriers
farriers113610742farriers
harriers113712432harriers
marriers103312472marriers
parriers103612902parriers
parsers94118152pars_ers
partiers103514242partiers
talliers83711372talliers
tansies74521242tansie_s
tapsters10318802tapsters
tardier859719992tardier_
tardies84225862tardie_s
tarrier74323172tarrier_
tarries73324262tarrie_s
tarsias74013372tarsi_as
tartier74123262tartier_
tassies74918932tassie_s
tasters74225642ta_sters
terriers84210822terriers
trashers113013642trashers
triers64321522t_r_iers
variers103712662var_iers
warslers11328072warslers
answers1037043_answers
arbiters1038853_arbiters
archers124414573_archers
arguers8489033_arguers
ariels65119373_ar_iels
arises65233803_arise_s
armers85520273_ar_mers
armies85123693_armie_s
armigers1135703_armigers
arrivers11137003_arrivers
arses55733873_ars_e_s
arsines73518813_arsines
arsis55722423_arsi__s
artier63419733_artier_
artsier768943_artsier_
askers105915403_a_skers
aspers86220313_a_spers
asters65631603_a_sters
ateliers837883ateliers
barbers114317503bar_bers
barbies114519593barbie_s
barkers134318513bar_kers
barkier133814483barkier_
barmier114313043barmier_
barnier93213673barnier_
barrier94017733barrier_
barters94223033bar_ters
bashers124820833ba_shers
basters94930303ba_sters
brasier94516753brasier_
braziers19397193braziers
briers85319733_br_iers
buriers94017193bur_iers
bursters1038983bursters
cahiers123510673ca_hiers
carders104820353car_ders
careers95218783car_eers
carers85133963car__ers
caressers1137433caressers
caries85147623car_ie_s
carnies94123963carnie_s
carolers103314173carolers
carpers114521253car_pers
carrier93619583carrier_
carries94328013carrie_s
carses85233653cars_e_s
carters95327253car_ters
carvers124817533car_vers
cashiers13318883cashiers
casters94729903ca_sters
causers94014793caus_ers
crashers134013233crashers
criers83918583_cr_iers
crosiers103312063crosiers
curriers103410753curriers
cursers94317163curs_ers
dabsters1137053dabsters
daisies84217093daisie_s
dalliers93610613dalliers
darbies104216983darbie_s
darers75921873dar__ers
darkies124015753darkie_s
darners83815773dar_ners
darters84017603dar_ters
dashers115016863da_shers
dassies84418663dassie_s
dorsers83516303dors_ers
dossiers9318043dossiers
driers74516733_dr_iers
earlier72612743earlier_
earners74016453ear_ners
easier64218463ea_sier_
easies64126633ea_sie_s
easters75125683ea_sters
erasers74413943eras_ers
falsies103515013falsie_s
fanciers13358083fanciers
farcers124713443far_cers
farcies125317883farcie_s
farers95924053far__ers
farmers124315263far_mers
farrier103514893farrier_
farriery14295403farriery
farsides1237993farsides
friers94718933_fr_iers
furriers11369493furriers
gagsters10317083gagsters
gambiers13337073gambiers
garblers113810283garblers
garglers10418263garglers
garners83815983gar_ners
garters84218233gar_ters
gaspers105014133ga_spers
gassers84714633ga_ssers
gassier83812573gassier_
gasters85624293ga_sters
gorsier83811073gorsier_
graspers11338403graspers
graziers18387123graziers
hamsters13710423hamsters
harassers1246193harassers
hardier114721543hardier_
hardies114923233hardie_s
harmers124116593har_mers
harpers124916203har_pers
harpies123818313harpie_s
harrier104417753harrier_
harries103525493harrie_s
harshens1437603harshens
harsher13310363harsher_
harslets1137833harslets
hauliers1176713hauliers
hawsers13409483haws_ers
horsier103013243horsier_
hosiers104212643_hosiers
hurriers11358893hurriers
jaspers164310463ja_spers
kaisers11369273kais_ers
kashers143914023ka_shers
lamsters1099753lamsters
lanciers10308543lanciers
lapsers93911053laps_ers
larders83516943lar_ders
lardier83518343lardier_
larkers113014513lar_kers
larkier113711523larkier_
lasers64925703la_s_ers
lashers104121833la_shers
lassies74420103lassie_s
lassoers8338513lassoers
lasters75627693la_sters
marblers12319233marblers
marchers153710813marchers
mariners103113863mariners
markers133516103mar_kers
marlier92614773marlier_
marrers93414313mar_rers
marrieds11288073marrieds
marrier93817523marrier_
marries93825283marrie_s
marses84827113mars_e_s
marshes123615373marshe_s
marshier1337593marshier_
masers84623453ma_s_ers
mashers124621053ma_shers
maskers133913843ma_skers
massier93615223massier_
masters94628923ma_sters
nursers74311833nurs_ers
osiers63412793__osiers
palsies94420273palsie_s
paniers94717333pa_niers
panniers10488853panniers
pansies94521983pansie_s
paraders113113113paraders
pardners11269193pardners
parers85530743par__ers
paries84742513par_ie_s
parises94827183parise_s
parkers133816873par_kers
parrier93717653parrier_
parries93925843parrie_s
parsecs11429923pars_ecs
parser84822373pars_er_
parses85534703pars_e_s
parsleys1335083parsleys
partier93520713partier_
parties93230863partie_s
partners102711133partners
partyers13277763partyers
passers94717753pa_ssers
pasters94531733pa_sters
patsies93919483patsie_s
pausers94113223paus_ers
pavisers13387443pavisers
praisers103410833praisers
priers84521193_pr_iers
pursers93916093purs_ers
pursier94012753pursier_
pursuers10376523pursuers
quarriers1845183quarriers
quartiers1845183quartiers
raisers73617393rais_ers
ralliers84010833ralliers
rapiers95012873ra_piers
rarefiers1244023rarefiers
rasers64526783ra_s_ers
rashers104020913ra_shers
raspers94415923ra_spers
rasters74629023ra_sters
risers64624783__risers
salliers83613343salliers
saltiers83411953saltiers
sarkier113413313sarkier_
sarsars73512143sars_ars
sarsens7311393sars_ens
sarsnets836783sarsnets
sassier73413233sassier_
sassies74719263sassie_s
sauciers1076733sauciers
starers74522313star__ers
starkers123712393star_kers
starrier8279463starrier_
starters83714773star_ters
startlers9236743startlers
starvers11459643star_vers
tabbies112913503tabbie_s
tabers84621573ta__bers
taborers10268333taborers
tackers134319623ta_ckers
tackier133712523tackier_
tacklers143010773tacklers
taffies133012693taffie_s
taggers93514193ta_ggers
tahsils1035053tahsi_ls
tailers73720183ta_ilers
takers103923743ta__kers
talers64628143ta__lers
talkers113513213ta_lkers
talkier114011843talkier_
talkies113415733talkie_s
tallier72817213tallier_
tallies73624603tallie_s
tamers84224033ta__mers
tamises92715973tamise_s
tammies113814683tammie_s
tampers113516743ta_mpers
tanagers9259003tanagers
tangier83013903tangier_
tanglers92911973tanglers
tankers113416913ta_nkers
tanners74018393ta_nners
taperers10269773taperers
tapers84025813ta__pers
tapirs84113173ta_pi_rs
tapises92914013tapise_s
tappers113416543ta_ppers
tapster9299273tapster_
tardiest93515243tardiest
tardiness10229913tardiness
tares57456563tar__e_s
targes74524593tar_ge_s
targets84314223tar_gets
tariffs1334593tar_iffs
tarpapers1344273tarpapers
tarres64723043tar_re_s
tarried83914133tarrie_d
tarriest83215003tarriest
tarriness9229243tarriness
tarsals72512603tars_als
tarsi55222173tarsi___
tarsia65514273tarsi__a
tarsus6310513tars__us
tartars73313403tar_tars
tarter64023563tar_ter_
tartiest82718313tartiest
tartiness92112053tartiness
tartlets8289663tartlets
tartness82210133tartness
tarweeds1244273tarweeds
tassels74510853ta_ssels
tasses64826763ta_sse_s
tassets75012773ta_ssets
tassie66017023tassie__
taster64930573ta_ster_
tastes64126423ta_ste_s
tastier711817093tastier_
taters64932203ta__ters
tatters74520483ta_tters
tattier74216243tattier_
tatties74120343tattie_s
tattlers8369693tattlers
taunters8259273taunters
tawers94118603ta__wers
tawnier10318463tawnier_
tawnies102812503tawnie_s
tawpies12309873tawpie_s
tawses94913193taws_e_s
taxers134015283ta__xers
taxies135817333ta_xie_s
teamsters1135973teamsters
tearers75218233tear__ers
tearier73815613tear_ier_
teasers75317243teas_ers
termers95414503ter_mers
terrier73414963terrier_
terries73425633terrie_s
terser67317823ters_er_
testers74124543t_esters
thirsters1235233thirsters
thrashers1565313thrashers
threshers1545423threshers
thrivers14456823thrivers
throwers14106033throwers
thrusters1245333thrusters
tidiers8389773t_idiers
tiers55526523t___iers
tipsier9268893tipsier_
tipsters10278513tipsters
toasters83912723toasters
topsiders1243023topsiders
torchiers1445073torchiers
tories65435883tor_ie_s
torquers17204303torquers
torses64727953tors_e_s
torsions839183torsions
tossers74713503t_ossers
tracers94917843t_racers
trackers143512853trackers
traders84316953t_raders
trailers82912923trailers
trainers83114643trainers
trampers123210393trampers
transfers1238053transfers
trappers123711043trappers
trasher104416133trasher_
trashes104119263trashe_s
trashier113210103trashier_
trasses74819323trasse_s
trawlers113310203trawlers
triens65417543t_r_iens
trier54328533t_r_ier_
tries55742813t_r_ie_s
trimers94615143t_rimers
trovers103713323t_rovers
trussers8348283trussers
trusters83112263trusters
trysters11298373trysters
turfier10249793turfier_
turners73912893tur_ners
turtlers8258203turtlers
tuskers113710043t_uskers
tussers74313563t_ussers
twiers95410163t__wiers
twisters11268173twisters
uprisers10206773uprisers
varier94619353var_ier_
varies94330873var_ie_s
verniers11227843verniers
versers103813523vers_ers
waisters113811523waisters
warblers13319103warblers
warders113416813war_ders
warier93722893war_ier_
warmers124514293war_mers
warners103315563war_ners
warpers123413583war_pers
warriors1135363warriors
warsler10289893warsler_
warsles103413643warsle_s
warstlers12284713warstlers
wartier103413913wartier_
washers134517523wa_shers
wasters104026593wa_sters
worriers11257813worriers
yarders113211593yar_ders
yarners104312203yar_ners

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623857.15620425.1
3Display Results3853850.1562467.9
 (SQL Overall)1786913857.73523101.6
 
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.