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

136 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
harpers12491620(None) 
carpers114521251carpers
hampers143616951hampers
harmers124116591harmers
harper115018401harper_
sharpers133810941sharpers
warpers123413581warpers
apers76629132_a_pers
armers85520272_armers
arpens84814822_arpens
aspers86220312_aspers
barbers114317502barbers
barkers134318512barkers
barters94223032barters
campers134220292campers
capers105428142ca_pers
cappers134419402cappers
carders104820352carders
careers95218782careers
carers85133962car_ers
carpels115315462carpels
carper104923632carper_
carpets113915332carpets
carters95327252carters
carvers124817542carvers
champers173311622champers
chargers144011322chargers
charmers154211332charmers
charters134115582charters
chirpers15358132chirpers
dampers123915692dampers
darers75921872dar_ers
darners83815772darners
darters84017602darters
dorpers104113172dorpers
drapers105313352drapers
earners74016452earners
farcers124713442farcers
farers95924052far_ers
farmers124315262farmers
gapers94520472ga_pers
garners83815982garners
garters84218232garters
gaspers105014132gaspers
gawpers13448312gawpers
hackers164619042hackers
hafters134614332hafters
hailers104017262hailers
halers94926912ha_lers
halters104619802halters
halvers133311422halvers
hammers144216062hammers
hamper134518652hamper_
hanapers1346962hanapers
handers114224332handers
hangers113120812hangers
hankers144218132hankers
happens14359172happens
harbors12412412harbors
hardens113815022hardens
harder105022402harder_
hareems12428202hareems
harems115513822har_ems
hares86255542har_e_s
harkens144112862harkens
harmer114719552harmer_
harness102413932harness
harped124418402harpe_d
harpies123818322harpies
harpins123615702harpins
harps105926872harp__s
harriers113712432harriers
haters94930402ha_ters
hatters104221522hatters
haulers104012442haulers
havers124721482ha_vers
hawkers174210332hawkers
hawsers13409482hawsers
hayers124415942ha_yers
hazers184615952ha_zers
heapers123616672heapers
hearers104319782hear_ers
helpers123311852helpers
herders113914122herders
herpes115517322herpe_s
hirers94518062hir_ers
hoarders12307432hoarders
hoopers123616492hoopers
hopers114222972h_opers
hoppers143115142hoppers
humpers142713522humpers
hurlers103714322hurlers
hurters103413642hurters
hypers144811912h_ypers
japers154616172ja_pers
jaspers164310462jaspers
lampers113817332lampers
lappers113717462lappers
larders83516942larders
larkers113014512larkers
mappers133313782mappers
markers133516102markers
marrers93414312marrers
nappers114214862nappers
pampers133615932pampers
papers105125322pa_pers
parers85530742par_ers
parkers133816872parkers
parsers94118152parsers
paupers114311072paupers
rapers84327182ra_pers
rappers113618442rappers
raspers94415922raspers
sappers113518902sappers
scarpers124712512scarpers
shapers124016892sha_pers
sharers104720622shar_ers
sharkers154011052sharkers
sharpens13377812sharpens
sharper124312702sharper_
tampers113516742tampers
tapers84025812ta_pers
tappers113416542tappers
vampers143111622vampers
variers103712662variers
warders113416812warders
warmers124514292warmers
warners103315562warners
warper114015582warper_
whappers18276742whappers
yappers144012252yappers
yarders113211592yarders
yarners104312202yarners
yaupers12337662yaupers
yawpers15346852yawpers
zappers203911632zappers

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.360496363.9
2DLD Change Limit1076711363.18633795.0
3Display Results1361360.0502720.0
 (SQL Overall)1786911363.59649691.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.