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

128 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
farriery1429540(None) 
farrier103514881farrier_
farriers113610741farriers
furriery14395671furriery
barrier94017732barrier_
barriers104311882barriers
carrier93619582carrier_
carriers103614202carriers
curriery13326162curriery
firrier103410122firrier_
furrier103513642furrier_
furriers11369482furriers
harrier104417752harrier_
harriers113712432harriers
marrier93817522marrier_
marriers103312472marriers
parrier93717652parrier_
parriers103612902parriers
tarrier74323172tarrier_
tarriers83411712tarriers
aerier64823153_aerier_
airier64619363_airier_
archery15478063_archery
ariary94114203_a_riary
arriver10117793_arriver_
arrivers11137003_arrivers
artery9911453_a_rtery
artier63419733_artier_
barkier133814483barkier_
barmier114313043barmier_
barnier93213673barnier_
barratry13114473barratry
barretry13115183barretry
briery114510773__briery
burrier93613543burrier_
carried103717153carrie_d
carries94328013carrie_s
charrier1378683charrier_
currier93316693currier_
curriers103410753curriers
derriere936043derriere
earlier72612743earlier_
faddier1237783faddier_
faerie93514683faerie__
faeries104118993faerie_s
faery116015483fa___ery
faggier12309843faggier_
fairer95212063fair_er_
fairies103516043fairie_s
fairy115318283fa__i_ry
fakery16509263fa__kery
fancier123412063fancier_
fanciers13358083fanciers
farcer115016083fa_rcer_
farcers124713443fa_rcers
farcie114816473farcie__
farcies125317883farcie_s
farer86733143fa_r_er_
farers95924053fa_r_ers
farmer115017373fa_rmer_
farmers124315263fa_rmers
farrieries1344343farrieries
farther1348343farther_
fattier103513463fattier_
fawnier13296363fawnier_
fernery1335813f_ernery
fernier103110813fernier_
ferrety13287013ferr_ety
ferried113411523ferrie_d
ferries103521083ferrie_s
fierier103511193fierier_
fiery114714793f___iery
firriest112310433firriest
forgery14419303f_orgery
forkier144311583forkier_
friary124010093f__riary
frier85225843f__rier_
friers94718933f__riers
furriest112910793furriest
furrily1337603furri_ly
furriner11267283furriner_
furriners12316303furriners
furzier19318093furzier_
hairier103111053hairier_
hardier114721543hardier_
harried113815533harrie_d
harries103525493harrie_s
hurrier103412933hurrier_
hurriers11358893hurriers
lardier83518343lardier_
larkier113711523larkier_
marlier92614773marlier_
marrer83716673marr_er_
marrers93414313marr_ers
married104715303marrie_d
marrieds11288073marrieds
marries93825283marrie_s
merrier92612303merrier_
orrery936783_orr_ery
parried103615723parrie_d
parries93925843parrie_s
partier93520713partier_
partiers103514243partiers
quarrier1736843quarrier_
quarriers1845183quarriers
sarkier113413313sarkier_
scarrier10298453scarrier_
sorrier72313723sorrier_
sparrier10329143sparrier_
starrier8279463starrier_
tardier859719993tardier_
tarried83914133tarrie_d
tarries73324263tarrie_s
tarriest83215003tarriest
tarsier74119253tarsier_
tarsiers8298533tarsiers
tartier74123263tartier_
terrier73414963terrier_
terriers84210813terriers
varier94619353va_rier_
variers103712663va_riers
variety1337743va_riety
warier93722893wa_rier_
warrior1045363warrior_
warriors1135363warriors
wartier103413913wartier_
worrier102311673worrier_
worriers11257813worriers

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.1561145455.1
2DLD Change Limit1461621287.70318974.7
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.90522604.8
 
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.