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

83 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
recolored124685(None) 
decolored1345661decolored
bicolored1443952bicolored
colored10313472__colored
decoloured1443082decoloured
recolor978692recolor__
recolors1078812recolor_s
recooked15268242reco_oked
recovered15166732recovered
tricolored1373632tricolored
uncolored1246962uncolored
coloreds1138093__coloreds
colorer9312523__colorer
coloured1148313__coloured
declared1248743dec_lared
decolor1087033decolor__
decolorized2445253decolorized
decolors1187713decolor_s
deplored1237223de_plored
discolored1445623discolored
explored1845073_explored
hectored1436873hec_tored
miscolored1544703miscolored
noncolored1354733noncolored
overcolored1744613overcolored
precooked1844993preco_oked
precooled1446363preco_oled
rebloomed1453283rebloomed
rebooked15226503rebo_oked
rebooted11248463rebo_oted
rebored105015883re__bored
recalled11310803recal_led
recensored1344253recensored
reckoned1546953rec_koned
reclined113613603rec_lined
reclothed1544593reclothed
recoaled113111783reco_aled
recoated113416783reco_ated
recocked17248473reco_cked
recoded113115033rec__oded
recoiled113613213reco_iled
recoined113614423reco_ined
recolonized2345153recolonized
recoloring1367583recoloring
recombed1536713reco_mbed
recomposed1744863recomposed
reconned113610653reco_nned
reconsoled1344553reconsoled
recontoured1453233recontoured
recopied1339843reco_pied
record96117423rec__or_d
recorded122511063reco_rded
recorked15239853reco_rked
recounted1238713recounted
recouped13128663reco_uped
recoupled1496163recoupled
recoverer14134973recoverer
recurred1137093rec_urred
reexplored2042623reexplored
reflooded1443553reflooded
reflowed15126903re_flowed
refolded1337063refol_ded
reglowed13125853re_glowed
relooked13236653relo_oked
remolded1237403remol_ded
replowed14127563re_plowed
repolled11359623repol_led
repoured1139563repo_ured
repowered1544663repowered
rerolled93010043rerol_led
reroofed1235873rero_ofed
rescored114513103re_scored
resoldered1243963resoldered
resoled84119283resol__ed
resolved12349343resol_ved
restored96417193re_stored
retailored1152963retailored
retooled938473reto_oled
revolted12319863revol_ted
revolved15328103revol_ved
sectored1138063sec_tored
varicolored1751543varicolored
vectored1435623vec_tored

Search took 7 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.1561145455.1
2DLD Change Limit148641836.67322275.0
3Display Results83830.0461804.3
 (SQL Overall)178691836.87525991.4
 
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.