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

72 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
bicolor114561(None) 
bicolors1256161bicolors
bicolour1243691bicolour
bicolored1443952bicolored
bicolours1343362bicolours
bipolar1145452bipolar
color76123742__color
decolor1087032decolor
discolor1146422discolor
miscolor1245602miscolor
recolor978692recolor
tricolor10115832tricolor
unicolor1043492unicolor
bachelor1564073bachelor
backlog1635773backlog
bailor83412603b_ailor
beclog1136863bec_log
bibelot1167343bibelot
bicker144819173bic_ker
bicorn103610103bico_rn
bicorne11297553bicorne
bicorns11338763bicorns
bicron103710773bic_ron
bicycler1742693bicycler
bifilar1244043bifilar
bifold1237223bifol_d
biller84923483bi_ller
billon83713833bi_llon
billow114111223bi_llow
biology1337363bi_ology
birler85715083bi_rler
bolar75123473b__olar
bolo65535953b__olo_
bolos75531373b__olos
boor66130683b__o_or
bricole112810493bricol_e
bricoles122610303bricoles
buckler154112033buckler
bucolic1345593bucolic
colog86619933__colog
colon78630193__colon
colors86622373__colors
colour85915093__colour
decolors1187713decolors
decolour1185013decolour
dipolar1056853dipolar
discolors1246593discolors
discolour1244173discolour
dolor67617963__dolor
eidolon844913eidolon
escolar946053escolar
fickler16348423fickler
gigolo836533gigolo_
gigolos934693gigolos
ichor1039483_ic_hor
isolog737403_isolog
lictor83610853lic_tor
mickler153310233mickler
miscolors1345863miscolors
nicol71113293nicol__
nicols8810243nicol_s
noncolor1046513noncolor
picador1245923picador
piccolo1354403piccolo_
piccolos1444133piccolos
picolin11310883picolin
recolors1078813recolors
tickler133612653tickler
timolol944113timolol
tricolors11125803tricolors
tricolour11114073tricolour
victor113210673vic_tor

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 Filter1786911340270.403443402.0
2DLD Change Limit134027726.65620136.3
3Display Results72720.0164500.0
 (SQL Overall)178691727.07525256.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.