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

310 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
terriers8421082(None) 
tarriers83411711tarriers
terrier73414961terrier_
terries73425631terrie_s
barriers104311882barriers
berries94423552berrie_s
carriers103614202carriers
curriers103410752curriers
decriers11299732decriers
derriere936042derriere
derrieres1044812derrieres
derries83124622derrie_s
farriers113610742farriers
ferries103521082ferrie_s
furriers11369492furriers
harriers113712432harriers
herries104025072herrie_s
hurriers11358892hurriers
jerries143817512jerrie_s
kerries113317912kerrie_s
marriers103312472marriers
merrier92612302merrier_
parriers103612902parriers
perries93226602perrie_s
serries73925352serrie_s
tarrier74323172tarrier_
tarries73324262tarrie_s
tarsiers8298532tarsiers
tearers75218232tear_ers
tearier73815612tearier_
termers95414502te_rmers
terreens8246532terreens
terrets72913582terr_ets
terrifiers13144572terrifiers
terrines82117552terrines
territs72714502terri_ts
terrors73112212terr_ors
triers64321522t__riers
verniers11227842verniers
worriers11257812worriers
aerier64823153ae_rier_
aeries64737783ae_rie_s
arrivers11137003_arrivers
ateliers837883ate_liers
barrier94017733barrier_
bearers94619593bear_ers
beerier93613023beerier_
beliers94617383be_liers
berried103714043berrie_d
breviers1335923breviers
briers85319733__briers
buriers94017193_buriers
burrers93814493burr_ers
burrier93613553burrier_
carrier93619583carrier_
carries94328013carrie_s
cherries131812983cherrie_s
corries94026803corrie_s
couriers103213173couriers
criers83918583__criers
currier93316703currier_
curriery13326163curriery
curries93723163currie_s
dearies83526273dearie_s
debriefs1433533debriefs
decreers11277623decreers
decrier102713553decrier_
decries103319803decrie_s
defiers113913993de_fiers
deifiers12348993deifiers
deniers84515183de_niers
deprivers1545213deprivers
derbies103016053derbie_s
deriders102411853deriders
derivers123811363derivers
dernier83011943dernier_
derricks1544433derricks
derringers1243843derringers
derris73615273derri__s
derrises93012783derrises
descriers1245693descriers
desirers939263desirers
destriers1038143destriers
deterrers10116593deterr_ers
driers74516733__driers
durries83817353durrie_s
earners74016453_earners
eerier64320023_eerier_
enviers1036993_enviers
erasers74413943_erasers
errors63311313_err_ors
eyries93816813_eyrie_s
farrier103514893farrier_
farriery14295403farriery
fearers104815273fear_ers
ferlies103216693ferlie_s
fernier103110823fernier_
ferrels10248623ferr_els
ferreters1246253ferreters
ferrets103111393ferr_ets
ferried113411523ferrie_d
ferrites112312833ferrites
firrier103410133firrier_
friers94718933__friers
furrier103513663furrier_
furriery14395683furriery
furriners12316323furriners
germier10309543germier_
gurries83515953gurrie_s
harrier104417753harrier_
harries103525493harrie_s
hearers104319783hear_ers
henries102718283henrie_s
herbier1239593herbier_
herders113914123he_rders
herried113514453herrie_d
herrings12379533herrings
hurrier103412943hurrier_
hurries103919653hurrie_s
jeerers14328923jeer_ers
jerkers18287083je_rkers
jerkier18407273jerkier_
jerkies183411583jerkie_s
jerreeds1653273jerreeds
jerrids15277743jerri_ds
kerrias11289513kerri_as
learier73415663learier_
learners8398153learners
leerier73111503leerier_
leviers103510343le_viers
lorries74518353lorrie_s
marrers93414313marr_ers
marrieds11288073marrieds
marrier93817523marrier_
marries93825283marrie_s
mercers114412773me_rcers
mercies113817563mercie_s
mergers103813423me_rgers
merriest10311483merriest
merriness1138293merriness
metiers93312843me_tiers
murries94118673murrie_s
nerdier83110353nerdier_
nervier10298833nervier_
parrier93717653parrier_
parries93925843parrie_s
partiers103514243partiers
pearlers1039033pearlers
peeries93623023peerie_s
perchers153611523perchers
perkier133813123perkier_
perusers10328803perusers
premiers122911653premiers
priers84521193__priers
quarriers1845183quarriers
queriers1736963queriers
rearers74323563rear_ers
redries83721713redrie_s
refries104419733refrie_s
reifiers11309843reifiers
reliers75519213re_liers
rentiers83311763rentiers
reorders9198833reorders
repliers103710163repliers
retirers84311533retirers
retries74129073retrie_s
rewriters1236343rewriters
sergers83815633se_rgers
series64540973se_rie_s
serried82513963serrie_d
servers103214833se_rvers
servicers1444663servicers
sherries111812893sherrie_s
skerries12168673skerrie_s
sorrier72313733sorrier_
spurriers11245063spurriers
starrier8279463starrier_
steadiers1035083steadiers
steerers82511353steer_ers
stirrers8266943stirr_ers
talliers83711373talliers
tardier859719993tardier_
tardies84225863tardie_s
tarres64723043tarr_e_s
tarried83914133tarrie_d
tarriest83215003tarriest
tarriness9229243tarriness
tarsier74119253tarsier_
tartier74123263tartier_
teachers133212393teachers
tearer64822903tear_er_
teariest82417263teariest
teariness9310633teariness
tearless848713tearless
teasers75317243te_asers
techier1269243techier_
techies12513603techie_s
tedders94010233te_dders
teddies92711283teddie_s
teemers95012903te_emers
teeners74415453te_eners
teenier72611143teenier_
teeters74018303te_eters
teethers11328713teethers
tekkies1035943tekkie_s
telfers10299073te_lfers
tellers73717603te_llers
tellies73820503tellie_s
telphers1335473telphers
tempers113513013te_mpers
tempters12257293tempters
tenders83719723te_nders
tenners74014923te_nners
tennies73017973tennie_s
tenoners858713tenoners
tenrecs936033tenr_ecs
tenters73921103te_nters
tentier73815923tentier_
terais64023513terai__s
terbias9310743terbi_as
terbiums1245423terbiums
tercels94110363te_rcels
terces83921413te_rce_s
tercets93512443te_rcets
tergites9310543tergites
termer85717253te_rmer_
terminus1037393terminus
termites10313693termites
termless1036233termless
termors94712773te_rmors
ternaries9311643ternarie_s
ternes65422903te_rne_s
ternions838813ternions
terraces102712253terraces
terrae62915213terrae__
terrains8410323terrains
terranes82514433terranes
terras63516973terr__as
terrases82111483terrases
terreen7257573terr_een
terrene72411033terr_ene
terrenes82212603terrenes
terret63425623terr_e_t
terrible1046643terrible
terribly1344923terribly
terrific1344803terrific
terrifier12126603terrifier_
terrifies12139723terrifies
terrify1336353terri_fy
terrine72517573terri_ne
territ63421373terri__t
territory1245103territory
terror63811733terr_or_
terser67317823te_rser_
tertials8510073tertials
tertians839103tertians
tertiary1145433tertiary
testers74124543te_sters
testier74015643testier_
tethers103815313te_thers
tetramers1146463tetramers
tetris62816293tetri__s
tetters74320473te_tters
theories11311593theorie_s
theorizers2243333theorizers
thrivers14456823thrivers
throwers14106033throwers
thurifers1542913thurifers
tidiers8389773t_idiers
tiers55526523t___iers
tirrivees1242003tirrivees
torchiers1445073torchiers
tories65435883t_orie_s
torquers17204303torquers
torrider936173torrider_
tourers73512743tour_ers
tracers94917843t_racers
traders84316953t_raders
trailers82912923t_railers
trainers83114643t_rainers
treaders93311843treaders
treaters83615843treaters
trekkers1133803trekkers
triens65417543t__riens
trier54328533t__rier_
tries55742813t__rie_s
trimers94615143t_rimers
trovers103713323t_rovers
turfier10249793turfier_
turners73912893t_urners
turrets73010673turr_ets
turtlers8258203turtlers
twiers95410163t__wiers
twirlers11274303twirlers
variers103712663_variers
veeries102916893veerie_s
verditers1344993verditers
vergers114412633ve_rgers
verier94620963ve_rier_
verifiers15166063verifiers
vernier102711273vernier_
versers103813523ve_rsers
warriors1135363warriors
wearers104615903wear_ers
wearier103613283wearier_
wearies103020223wearie_s
wherries14179023wherrie_s
worrier102311683worrier_
worries104117133worrie_s
yearners11346373yearners

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623107.59319249.6
3Display Results3103100.1232520.3
 (SQL Overall)1786913108.13921954.9
 
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.