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

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
tricolors1112580(None) 
tricolor10115831tricolor_
tricolours12133961tricolours
bicolors1256162_bicolors
recolors1078812_recolors
tricolored1373632tricolored
tricolour11114072tricolour
trimotors1145142trimotors
bicolor1145613_bicolor_
bicolours1343363_bicolours
bricoles122610303bricol_es
colors86622373___colors
decolors1187713_decolors
discolors1246593discolors
frivolers1543473frivolers
frivolous1553163frivolous
miscolors1345863miscolors
noncolors1147033noncolors
recolor978693_recolor_
tailors73212393tai__lors
terricolous1352413terricolous
ticklers14339303t_icklers
timolols1044333t_imolols
tractors10312573trac_tors
tremolos1046043tremolo_s
tribology1545123tribology
trichology1944843trichology
trickers143812813tric_kers
trickles143013763trickl_es
triclads1146233tric_lads
tricorn937963tric__orn
tricornes1146233tricornes
tricorns1036683trico_rns
tricots9311563tric__ots
triflers113110213tri_flers
trigonous1045303trigonous
trillers83613493tri_llers
trimotor1044813trimotor_
triolets83410143tri_olets
triols66117803tri_ol__s
tripolis1038713tripol_is
trucklers15295583trucklers
unicolor1043493unicolor_

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit148641437.48619855.9
3Display Results43430.0133307.7
 (SQL Overall)178691437.91922564.8
 
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.