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

332 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
farriers11361074(None) 
barriers104311881barriers
carriers103614201carriers
farrier103514881farrier_
farriery14295401farriery
furriers11369481furriers
harriers113712431harriers
marriers103312471marriers
parriers103612901parriers
tarriers83411711tarriers
arrivers11137002_arrivers
barrier94017732barrier_
carrier93619582carrier_
carries94328012carrie_s
curriers103410752curriers
faeries104118992faerie_s
fairies103516042fairie_s
fanciers13358082fanciers
farcers124713442fa_rcers
farcies125317882farcie_s
farers95924052fa_r_ers
farmers124315262fa_rmers
farrieries1344342farrieries
ferries103521082ferrie_s
firrier103410122firrier_
friers94718932f__riers
furrier103513642furrier_
furriery14395672furriery
furriners12316302furriners
harrier104417752harrier_
harries103525492harrie_s
hurriers11358892hurriers
marrers93414312marr_ers
marrieds11288072marrieds
marrier93817522marrier_
marries93825282marrie_s
parrier93717652parrier_
parries93925842parrie_s
partiers103514242partiers
quarriers1845182quarriers
tarrier74323172tarrier_
tarries73324262tarrie_s
tarsiers8298532tarsiers
terriers84210812terriers
variers103712662va_riers
warriors1135362warriors
worriers11257812worriers
aerier64823153_aerier_
aeries64737783_aerie_s
airers64922313_air_ers
airier64619363_airier_
arbiters1038853_arbiters
archers124414573_archers
arguers8489023_arguers
ariels65119373_a_riels
armers85520273_a_rmers
armies85123693_armie_s
armigers1135703_armigers
arrayers11125853_arrayers
arrears738843_arrears
arris56824683_arri__s
arrises71617583_arrises
arriver10117793_arriver_
arrives101311513_arrives
artier63419733_artier_
barbers114317503ba_rbers
barbies114519593barbie_s
barkers134318513ba_rkers
barkier133814483barkier_
barmier114313043barmier_
barnier93213673barnier_
barraters1138033barraters
barrels94514363barr_els
barrens94414323barr_ens
barres84427543barr_e_s
barrets94917103barr_ets
barrios9310773barri_os
barristers1244723barristers
barters94223033ba_rters
berries94423553berrie_s
brasiers103710513brasiers
braziers19397193braziers
briers85319733__briers
buriers94017193_buriers
burrers93814493burr_ers
burrier93613543burrier_
cahiers123510673ca_hiers
carders104820353ca_rders
careers95218783ca_reers
carers85133953ca_r_ers
caries85147623ca_rie_s
carnies94123963carnie_s
carolers103314173carolers
carpers114521253ca_rpers
carrels95117303carr_els
carried103717153carrie_d
carrions10312443carrions
carters95327243ca_rters
carvers124817533ca_rvers
cashiers13318883cashiers
catbriers1344143catbriers
charrier1378683charrier_
corries94026783corrie_s
couriers103213163couriers
criers83918583__criers
currier93316693currier_
curriery13326163curriery
curries93723163currie_s
dairies84217733dairie_s
dalliers93610613dalliers
darbies104216983darbie_s
darers75921873da_r_ers
darkies124015753darkie_s
darners83815773da_rners
darters84017603da_rters
decriers11299733decriers
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
driers74516733__driers
durries83817353durrie_s
earlier72612743earlier_
earners74016453ea_rners
earrings9299623earrings
fablers124812613fa_blers
fabrics1436093fabri_cs
facers115519443fa__cers
facies113921593fa_cie_s
faddier1237783faddier_
faders105117463fa__ders
faerie93514683faerie__
faggier12309843faggier_
fagoters1234853fagoters
fainters11349693fainters
fairer95212063fair_er_
fairgoers1342013fairgoers
fairings12388193fairings
fairness1136563fairness
fairs85825443fa__i_rs
fakeers14446673fa_keers
fakeries1559833fakerie_s
fakers134219533fa__kers
fakirs13468083fa_ki_rs
fallers103917993fa_llers
falsies103515013falsie_s
falters103916473fa_lters
fancier123412063fancier_
fancies124018783fancie_s
fanners103914653fa_nners
fannies103415643fannie_s
faqirs18456033fa_qi_rs
faquirs1943863faqui_rs
faradizers23223643faradizers
farcer115016083fa_rcer_
farces115223323fa_rce_s
farceurs13464723farceurs
farcie114816473farcie__
fardels11389893fa_rdels
farer86733143fa_r_er_
fares85852873fa_r_e_s
farfels13348213fa_rfels
farinas103215233fa_rinas
farles96025783fa_rle_s
farmer115017373fa_rmer_
farmings14298213farmings
farness102912203fa_rness
farrows13259783farr_ows
farsides1237993farsides
farther1348343farther_
fartleks1533963fartleks
fathers133916503fa_thers
fattier103513463fattier_
fatties103018203fattie_s
favorers1465493favorers
fawners13388493fa_wners
fawnier13296363fawnier_
fearers104815273fear_ers
ferlies103216693ferlie_s
fernier103110813fernier_
ferrels10248623ferr_els
ferreters1246253ferreters
ferrets103111393ferr_ets
ferried113411523ferrie_d
ferrites112312823ferrites
fierier103511193fierier_
firers94922683f_ir_ers
firmers124711443f_irmers
firriest112310433firriest
fliers94417193f__liers
flirters11337933flirters
flurries11188893flurrie_s
flytiers14254483flytiers
foragers12349623foragers
forayers14277273forayers
forcers124215713f_orcers
forevers1438173forevers
forgers115218183f_orgers
forgivers1643713forgivers
forgoers1236413forgoers
forkers144615783f_orkers
forkier144311583forkier_
formers128217953f_ormers
forties104323863fortie_s
framers125113823f_ramers
frankers15348353frankers
fraters103517203f_raters
freers94717303f__reers
friars93812093f__riars
frier85225843f__rier_
fries85535603f__rie_s
frizers19329553f_rizers
fruiters11328173f_ruiters
fryers125710973f__ryers
fuhrers1334813fuhr_ers
furies95126373f_urie_s
furlers104214223f_urlers
furrieries1343933furrieries
furriest112910793furriest
furriner11267283furriner_
furriness12287593furriness
furrings12317123furrings
furrowers1563503furrowers
furthers1436493furthers
furzier19318093furzier_
gambiers13337073gambiers
garblers113810283garblers
garglers10418263garglers
garners83815983ga_rners
garrets84413623garr_ets
garroters1055813garroters
garters84218223ga_rters
gharries12318203gharrie_s
graziers18387123graziers
gurries83515953gurrie_s
hagriders1443553hagriders
hairier103111053hairier_
hardier114721543hardier_
hardies114923233hardie_s
harmers124116593ha_rmers
harpers124916203ha_rpers
harpies123818313harpie_s
harried113815533harrie_d
harrowers1555683harrowers
hauliers1176713hauliers
herries104025073herrie_s
hurrier103412933hurrier_
hurries103919653hurrie_s
jerries143817513jerrie_s
kauries113613193kaurie_s
kerries113317913kerrie_s
lanciers10308543lanciers
larders83516943la_rders
lardier83518343lardier_
larkers113014513la_rkers
larkier113711523larkier_
larrupers1142523larrupers
lorries74518343lorrie_s
marblers12319233marblers
marchers153710813marchers
mariners103113863mariners
markers133516103ma_rkers
marlier92614773marlier_
marrer83716673marr_er_
married104715303marrie_d
merrier92612303merrier_
murries94118673murrie_s
narraters946693narraters
paniers94717333pa_niers
panniers10488853panniers
paraders113113113paraders
pardners11269193pardners
parers85530743pa_r_ers
paries84742513pa_rie_s
parkers133816873pa_rkers
parrels94713493parr_els
parried103615723parrie_d
parroters1156763parroters
parsers94118153pa_rsers
partier93520713partier_
parties93230863partie_s
partners102711133partners
partyers13277763partyers
perries93226603perrie_s
priers84521193__priers
quarrier1736843quarrier_
quarries1749943quarrie_s
quartiers1845183quartiers
queriers1736963queriers
ralliers84010833ralliers
rapiers95012873ra_piers
rarefiers1244023rarefiers
salliers83613333salliers
saltiers83411953saltiers
sarkier113413313sarkier_
sauciers1076733sauciers
sauries72821623saurie_s
scarrier10298453scarrier_
serries73925353serrie_s
sorrier72313723sorrier_
sparrier10329143sparrier_
spurriers11245063spurriers
starrier8279463starrier_
talliers83711363talliers
tardier859719993tardier_
tardies84225863tardie_s
tarres64723043tarr_e_s
tarried83914133tarrie_d
tarriest83215003tarriest
tarriness9229243tarriness
tarsier74119253tarsier_
tartier74123263tartier_
terrier73414963terrier_
terries73425613terrie_s
triers64321523__triers
varier94619353va_rier_
varies94330873va_rie_s
verniers11227843verniers
warblers13319103warblers
warders113416813wa_rders
warier93722893wa_rier_
warmers124514293wa_rmers
warners103315563wa_rners
warpers123413583wa_rpers
warreners1236193warreners
warrens103810893warr_ens
warrior1045363warrior_
warslers11328073warslers
wartier103413913wartier_
worrier102311673worrier_
worries104117133worrie_s
yarders113211593ya_rders
yarners104312203ya_rners

Search took 10 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.236757165.3
2DLD Change Limit1461623328.62316950.2
3Display Results3323320.1262634.9
 (SQL Overall)1786913328.98519887.7
 
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.