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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
carpus10551430(None) 
campus125213921campus
carps96932251carp_s
corpus106015291corpus
acarpous1245312acarpous
acarus8312192acar_us
arcus76918862_arcus
argus66716542_argus
cactus104912232cactus
callus85317072callus
campos125217952campos
camps116330262camp_s
cantus85117762cantus
capes95441922ca_pes
caphs124515372ca_phs
capos94826072ca_pos
capris10415082capris
caps87147892ca_p_s
caput9823982ca_put
carats85929022carats
carbos105122262carbos
carbs96031462car_bs
cards85137932car_ds
carers85133962carers
cares77369182car_es
caress85720262caress
carets85330772carets
carful11610972carful
carfuls1249132carfuls
cargos94619182cargos
caries85147622caries
carious93320282carious
carks115534212car_ks
carles85435082carles
carls77037422car_ls
carns75937562car_ns
carobs104818102carobs
carols85124982carols
carolus94612602carolus
caroms105619572caroms
carouse9614422carouse
carp85139812carp__
carpal103716252carpal
carpals113414622carpals
carped115923762carped
carpel105418472carpel
carpels115315462carpels
carper104923632carper
carpers114521252carpers
carpet104530092carpet
carpets113915332carpets
carpi94319392carp_i
carrs75730852car_rs
cars67364762car__s
carses85233652carses
cartes86239472cartes
carts78946292car_ts
carves115128452carves
casus76419252ca_sus
caucus1039612caucus
cercus105013152cercus
cereus85215522cereus
cerous85821202cerous
circus104310592circus
cirrus8349172cirrus
cornus84816562cornus
corps95927042corp_s
coypus13389302coypus
crapes104727692crapes
craps95328642crap_s
crus65828482c_r_us
cyprus1335362cyprus
harps105926872harp_s
palpus104210282palpus
pappus9408372pappus
pareus85420742pareus
parous84024162parous
scarphs14437412scarphs
scarps104718602scarp_s
tarps76527112tarp_s
tarsus6310512tarsus
varus85921182var_us
wampus13499012wampus
warps107126422warp_s

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 Filter178691825510.343520965.0
2DLD Change Limit82551842.65631080.9
3Display Results84840.0332545.5
 (SQL Overall)178691843.03258935.0
 
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.