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

56 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
darics9431411(None) 
daric85623121daric_
agarics10319942agarics
arcs67834782_ar_cs
arias55438022_arias
arils58732202_arils
baric96125692baric_
basics104915122basics
carices114220952carices
caries85147622caries
dairies84217732dairies
dais57040702da_i_s
danios7314602danios
darbies104216982darbies
darbs85323262dar_bs
darers75921872darers
dares66146702dar_es
daring84928682daring
darings93713652darings
darkies124015752darkies
darks106727872dar_ks
darns66927892dar_ns
darts67635732dar_ts
davies105020512davies
davits104012362davits
dearies83526272dearies
diaries83321952diaries
dories75232362dories
drails74716952drails
drains73719402drains
dribs85115062d_ribs
dries64733672d_ries
drips85417232d_rips
durocs9569702durocs
dyadics1453472dyadics
fabrics1436092fabrics
garlics1038012garlics
laics76419252la_ics
laris54737462lari_s
lyrics11357942lyrics
magics115311612magics
manics103919932manics
marcs95726622mar_cs
narcs76122022nar_cs
naric76824172naric_
naris55735292nari_s
panics103815362panics
paries84742522paries
paris75145942pari_s
sarins63932622sarins
saris54544952sari_s
tarocs84615662tarocs
torics85118352torics
varias95019902varias
varices123313572varices
varies94330872varies

Search took 6 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.686260482.5
2DLD Change Limit82551564.94016710.7
3Display Results56560.0163500.0
 (SQL Overall)178691565.64231671.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.