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 “farmers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
farmers12431526(None) 
armers85520271_armers
farcers124713441farcers
farers95924051far_ers
farmer115017371farmer_
firmers124711441firmers
formers128217951formers
framers125113821framers
harmers124116591harmers
warmers124514291warmers
aimers84621912_aimers
armer76924442_armer_
armets84918352_armets
armors85017812_armors
barbers114317502barbers
barkers134318512barkers
barters94223032barters
carders104820352carders
careers95218782careers
carers85133962car_ers
carpers114521252carpers
carters95327252carters
carvers124817532carvers
charmers154211332charmers
dammers123214272dammers
darers75921872dar_ers
darners83815772darners
darters84017602darters
dormers104313922dormers
earners74016452earners
fablers124812612fablers
facers115519442fa_cers
faders105117462fa_ders
fakeers14446672fakeers
fakers134219532fa_kers
fallers103917992fallers
falters103916472falters
fames105735922fa_me_s
fanners103914652fanners
farcer115016082farcer_
farces115223322farce_s
farceurs13464722farceurs
fardels11389892fardels
farer86733142far_er_
fares85852872far_e_s
farfels13348212farfels
farles96025782farle_s
farmed125117652farme_d
farms106324952farm__s
farness102912202farness
farriers113610742farriers
fathers133916502fathers
fawners13388492fawners
fearers104815272fear_ers
filmers124211292filmers
firers94922682fir_ers
firmer114712442firmer_
flamers124616362flamers
foamers123812102foamers
forcers124215712forcers
forgers115218182forgers
forkers144615782forkers
former114221402former_
formes114623712forme_s
framer114817442framer_
frames115119862frame_s
fraters103517212fraters
freers94717302f_reers
friers94718932f_riers
fryers125710972f_ryers
fumers113613382f_umers
furlers104214222furlers
gamers94420832ga_mers
gammers123214562gammers
garners83815982garners
garters84218232garters
hammers144216062hammers
harmer114719552harmer_
harpers124916202harpers
jammers183710702jammers
larders83516942larders
larkers113014512larkers
maimers113813042maimers
mammers104615692mammers
markers133516102markers
marrers93414312marrers
namers84517332na_mers
ormers84316142_ormers
palmers113513622palmers
parers85530742par_ers
parkers133816872parkers
parsers94118152parsers
rammers113715042rammers
swarmers1346322swarmers
tamers84224032ta_mers
termers95414502termers
variers103712662variers
warders113416812warders
warmer113816732warmer_
warners103315562warners
warpers123413582warpers
wormers124012572wormers
yammers143410322yammers
yarders113211592yarders
yarners104312202yarners

Search took 4 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 Filter1786911076710.1401276364.3
2DLD Change Limit1076711052.94036622.8
3Display Results1051050.0303500.0
 (SQL Overall)1786911053.11057456.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.