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

76 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
recoloring136758(None) 
decoloring1486311decoloring
coloring11414842__coloring
decolouring1583432decolouring
recooking16148542reco_oking
recovering1647372recovering
colorings1247683__colorings
colouring1258723__colouring
declaring1339573dec_laring
decolorize2256063decolorize
decolorizing2555133decolorizing
deploring1337853de_ploring
discoloring1544743discoloring
exploring1945543_exploring
hectoring1538303hec_toring
miscoloring1644263miscoloring
overcoloring1844693overcoloring
precooking1945043preco_oking
precooling1545963preco_oling
reblooming1543423reblooming
rebooking16146393rebo_oking
rebooting12139023rebo_oting
reboring11312783re__boring
recalling122211903recal_ling
recensoring1444673recensoring
rechoosing1645373rechoosing
reckoning1637643rec_koning
reclining121112283rec_lining
reclothing1644973reclothing
recoaling121312453reco_aling
recoating121317463reco_ating
recocking18138373reco_cking
recoding122213853rec__oding
recoiling121412413reco_iling
recoining121313803reco_ining
recolonize2145573recolonize
recolonizing2455363recolonizing
recolor978693recolor___
recolored1246853recolor_ed
recolors1078813recolor__s
recombing1637323reco_mbing
recomposing1844223recomposing
reconning121410793reco_nning
reconsoling1444483reconsoling
recontouring1553253recontouring
recopying1737113reco_pying
recording131311623reco_rding
recorking16149643reco_rking
recounting1339183recounting
recouping1438363reco_uping
recoupling1545043recoupling
recurring1237953rec_urring
reexploring2152593reexploring
reflooding1544053reflooding
reflowing1636523re_flowing
refolding1437453refol_ding
reglowing1436173re_glowing
relooking14167143relo_oking
remolding1338163remol_ding
replowing1537413re_plowing
repolling122110203repol_ling
repouring12310073repo_uring
repowering1645273repowering
rerolling102210373rerol_ling
reroofing1336863rero_ofing
rescoring12310603re_scoring
resoldering1343993resoldering
resoling92916303resol__ing
resolving1337743resol_ving
restoring10314603re_storing
retailoring1243723retailoring
retooling1039093reto_oling
revolting1339633revol_ting
revolving1635843revol_ving
sectoring1239583sec_toring
vectoring1537413vec_toring

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 Filter1786911406030.1561145455.1
2DLD Change Limit140603767.54618632.8
3Display Results76760.0461652.2
 (SQL Overall)178691767.74823062.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.