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

43 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
acarus831219(None) 
abacus10349762abacus
acajous1666482acajous
acari75020282acar_i
acarid95017072acarid
acarids105312242acarids
acarpous1245312acarpous
accrue1035822accrue
accrues1135322accrues
acerous9513332acerous
acinus8311252acinus
acorns85013012acorns
acres76327762ac_res
afars85716512afar_s
agars66120642agar_s
alarms85913052alarms
alarum85411982alarum
alarums9408922alarums
asarum84610912asarum
asarums9467612asarums
ascaris93613322ascaris
awards107113452awards
carbs96031462_carbs
cards85137932_cards
cares77369182_cares
carks115534212_carks
carls77037422_carls
carns75937562_carns
carps96932252_carps
carpus105514302_carpus
carrs75730852_carrs
cars67364762_car_s
carts78946292_carts
casus76419252_casus
crus65828482_c_rus
ecrus75113862ec_rus
scares85033002scares
scarfs114714682scarfs
scarps104718602scarps
scars75433532scar_s
scarts85321492scarts
scaurs85512052scaurs
varus85921182_varus

Search took 3 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.326548131.9
2DLD Change Limit82551432.32635490.5
3Display Results43430.000 
 (SQL Overall)178691432.65267379.7
 
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.