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

152 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
vigours1128548(None) 
rigours8206991rigours
vigors102911481vigo_rs
vigour10256801vigour_
giaours834562giaours
pigouts1037592pigouts
rigors72813712rigo_rs
rigour7258022rigour_
valours10248732valours
vapours12277452vapours
velours10278082velours
vigor92612422vigo_r_
vinous93914172vinou_s
visors92912222viso_rs
vizors18328902vizo_rs
algors7312553algo_rs
amours83512643_amours
arbours93910033arbours
ardours8368873ardours
armours9389843armours
augurs7399963aug_urs
bigos85020013bigo__s
bigoses1039073bigoses
bigotry1344523bigotry
bigots95015133bigo_ts
bijous1548043bijou_s
bugouts1036193bugouts
cigars9910713cig_ars
clours85215083_clours
colours95913413colours
detours858033detours
devours1166643devours
diggers104413383diggers
dimouts1037893dimouts
diseurs839403diseurs
dolours8438813dolours
dugouts935043dugouts
dyvours1453183dyvours
faitours1134253faitours
favours13437083favours
figure10258833fig_ure
figures11239103fig_ures
flours94414053_flours
fours85521493__fours
gaurs66317993__gaurs
giaour735363giaour_
gigolos934693gigolos
gigots83911953gigo_ts
gigues8128993gig_ues
goers65520253__goers
gourd71011903__gourd
gourds8108253__gourds
gouts64826173__gouts
haviours1443833havi_ours
honours10339353honours
hours85422383__hours
humours1286413humours
iglus6609933_iglu_s
incurs83012273_incurs
inpours936413inpours
jiggers164010173jiggers
labours9349883labours
ligers75022033lig_ers
ligure7279473lig_ure
ligures8269883lig_ures
liquors1634433liquors
lours55125293__lours
miaous8511693miaou_s
minors85117093mino_rs
muggurs11315103muggurs
niggers93111313niggers
odours7418233_odours
ours47237563___ours
paviours1343613pavi_ours
pignus937953pignu_s
pignuts1035613pignuts
pigout9314613pigou_t
pilous84717753pilou_s
pious74621273pi_ou_s
pours74623183__pours
ragouts838533ragouts
repours9310223repours
riggers93613833riggers
rigor62714053rigo_r_
rimous8311913rimou_s
rugous739643rugou_s
rumours976363rumours
sapours93610613sapours
saviours1154273savi_ours
savours10389333savours
scours84913583_scours
siddurs934173siddurs
sieurs659043si_eurs
sighers113712173sighers
signers84714433signers
signors83410903signors
sours55230503__sours
stours65015623_stours
tabours94110073tabours
tenours72610053tenours
tigers75616503tig_ers
tigons74112253tigo_ns
tours55325863__tours
tumours976733tumours
vagus96713813vag_u_s
valors93413773valo_rs
valour93010373valour_
vapors113812693vapo_rs
vapour11378873vapour_
vapoury15284803vapoury
velour9328763velour_
venous93713193venou_s
vetoers10359473vetoers
viators102712013viators
vicars11712263vi_cars
vicious1239493viciou_s
victors123311173victors
viers85621953vi__ers
viewers1337173viewers
vigas94817883vig__as
vigias104110893vig_ias
vigils104210193vig_ils
vigorish1545173vigorish
vigoroso1242193vigoroso
vigorous1245763vigorous
vigs85427273vig___s
villous102810013villou_s
villus93611223villu_s
vinos84723073vino__s
violas93713523vi_olas
viols86118103vi_o_ls
vipers114914533vi_pers
viroids1137923viroids
viroses10310533viroses
virosis1039023virosis
virtues10338023virtues
virtus94310143virtu_s
virus85316843vi_ru_s
viscous1238833viscou_s
viscus11428503viscu_s
visor82512833viso_r_
vivers124717363vi_vers
viziers19336203viziers
vizirs18306713vi_zirs
vizor173010093vizo_r_
vodouns1134753vodouns
vodous1038593vodou_s
voguers11356683voguers
vogues104011923vog_ues
voyeurs1332423voyeurs
vrouws12494743v_rouws
yours85217873__yours

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.1561145455.1
2DLD Change Limit1340271527.14018771.3
3Display Results1521520.0463304.3
 (SQL Overall)1786911527.34224338.2
 
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.