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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
savourer113447(None) 
favourer1443821favourer
savorer1057881savo_rer
savoured1234791savoured
savourers1243831savourers
savourier1242971savourier
devourer1235062devourer
favorer1355882favo_rer
favoured1533962favoured
favourers1543122favourers
labourer1045752labourer
savored1158342savo_red
savorers1157222savo_rers
savorier1136642savorier
savour94110702savou__r
savouries1245472savouries
savours10389332savour_s
savoury13365872savour_y
scourer93910432s_courer
sourer63620212s__ourer
tabourer1035742tabourer
vapourer1344262vapourer
abjurer1634743_abjurer
adjurer1534803_adjurer
adorer74713443_ado_rer
allurer7348433_allurer
armourer1054883armourer
arouser74514423_arouser
assurer767783_assurer
augurer8136343_augurer
avoider1155813_avoider
avoucher1653853_avoucher
avower1236823_avo_wer
capturer1246083capturer
carouser1068843carouser
cavorter1335783cavorter
colourer1037553colourer
devoured1335723devoured
devourers1344093devourers
devouter1235513devouter
dourer74215273__dourer
favored1455983favo_red
favorers1465493favo_rers
favour12438333favou__r
favours13437083favour_s
flavorer1454553flavo_rer
flavoured1642973flavoured
havocker2042393havocker
honourer1146243honourer
laborer9249503labo_rer
laboured1156323laboured
labourers1144713labourers
manurer938583ma_nurer
maturer938973ma_turer
pasturer1037523pasturer
pourer84516043__pourer
saluter73512453sa_luter
sapour83812373sapou__r
sapours93610613sapour_s
saucer84314103sa__ucer
sauger74316253sa__uger
saurel6511983sa__urel
savager1137133sav_ager
saver84831253sav___er
saviour1035213saviou__r
saviours1154273saviour_s
savor85417943savo___r
savories11311273savories
savors95616103savo_r_s
savory124310563savo_r_y
savouriest1343033savouriest
savouring1335193savouring
savvier1335483sav_vier
scorer84818253s_co_rer
scoured103811153s_coured
scourers10348533s_courers
scourger1134723s_courger
scouter93313323s_couter
securer958253s_ecurer
severer103511563sev_erer
shnorrer1143513shnorrer
shouter103213073s_houter
slaverer11196993slav_erer
snorer64316763s_no_rer
soarer64522243s__oarer
sojourner1661713sojourner
sorer56236573s__o_rer
soured74921863s__oured
souter64225923s__outer
spouter94213223s_pouter
storer64721673s_to_rer
stoure64814943s_toure_
stoures74614163s_toures
stouter74012053s_touter
surer54833093s___urer
taborer9269293tabo_rer
taboured1156273taboured
tabourers1144673tabourers
tabouret1049173tabouret
tambourer1343493tambourer
tourer64115073__tourer
vaporer1236983vapo_rer
vapoured1434353vapoured
vapourers1443373vapourers
waverer13319523wav_erer

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621056.82621412.5
3Display Results1051050.0303500.0
 (SQL Overall)1786911057.02925422.0
 
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.