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

142 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
resinous83850(None) 
rosinous847371rosinous
cretinous1145892cretinous
desirous947782desirous
heinous1038852he_inous
resinoid946412resinoid
resinoids1044702resinoids
resins64528772resin__s
retinols8419742retinols
rosinols845672rosinols
ruinous739762r_uinous
acinous9310933_acinous
anginous947643anginous
arenous7314183are__nous
arsenious945223arsenious
arsenous847533arsenous
arsonous846393arsonous
besnows1245153bes_nows
casinos93512833casino_s
criminous1375323criminous
devious1138523devi_ous
enginous946493enginous
estrous7712533_estrous
laminous1037953laminous
lesions73813873lesi_ons
luminous1037113luminous
melanous1048603melanous
merinos9311983merino_s
mestinoes1157313mestinoes
mestinos1048163mestino_s
mucinous1245373mucinous
mutinous1047653mutinous
numinous1046293numinous
oestrous869923oestrous
ominous949033_ominous
pectinous1345553pectinous
pepinos1137693pepino_s
perilous10310693perilous
precious12310593preci_ous
previous1337823previ_ous
rainout7314393r_ainout
rainouts846913r_ainouts
ravenous1146793ravenous
rebinds104511873rebin_ds
refinds114512123refin_ds
refiners114713313refiners
refines105426343refin_es
reginas85614063regin_as
regions83613473regi_ons
regius7311923regi__us
rehinges1248403rehinges
reincur945133re_incur
reincurs1045553re_incurs
reinfuse1144783re_infuse
reinks105012153re_in_ks
reins56234563re_in__s
reknots1136783re_knots
religious1076033religious
relines75331323relin_es
relinks114510223relin_ks
reminds104614793remin_ds
remints95117293remin_ts
renins64526453renin__s
repiners103913433repiners
repines94927383repin_es
repins84924313repin__s
rescinds1136333rescin_ds
reseaus74012153res_eaus
resends83513713resen_ds
resents74221223resen_ts
reshines112615443reshin_es
reshoes102316033res_hoes
reshoots11228413reshoots
reshows132510453res_hows
residers93311883residers
resides84523283resi_des
resids74219153resi__ds
residua8286623resi_dua
residue8689863resi_due
residues9338813residues
residuum1143063residuum
residuums1251903residuums
resifts10378703resi_fts
resights1246733resights
resigners1036863resigners
resigns83910963resi_gns
resiles74026543resi_les
resilins83013373resilins
resin54131053resin___
resinate8316773resinate
resinates9314763resinates
resined84522653resin_ed
resinify1445053resinify
resining92919553resining
resiny94617363resin__y
resistors947993resistors
resists74414923resi_sts
resites74027793resi_tes
resits64725563resi__ts
resizes164216843resi_zes
resods74116303res__ods
resows93915353res__ows
responds1136913responds
respools1036253respools
respots92912763res_pots
resprout1078783resprout
resprouts1174823resprouts
retinals85612963retinals
retinas74819353retin_as
retines75134673retin_es
retinoid947353retinoid
retinoids1045383retinoids
retinol7469693retino_l
retints74717013retin_ts
retinue75414843retin_ue
retinues85113153retinues
retsinas8387963retsin_as
reunions837273reunions
revisors11379063revisors
rewinds114810483rewin_ds
rewins95020823rewin__s
rexines144719153rexin_es
rhinos94411123r_hino_s
ricinus9408123ricin_us
rimous8311913r__imous
risings83211893risin_gs
rosiness82613173rosiness
rosinol756323rosino_l
rosins64521863rosin__s
rubious938283rubi_ous
selenous848973selenous
serious73616283seri_ous
sinuous739063__sinuous
sinus55523853__sin_us
spinous9310443_spinous
tedious838443tedi_ous
tendinous1044623tendinous
treasonous1052693treasonous
urinous7310083_urinous
venous93713193ve__nous
verminous1445573verminous
vinous93914173__vinous

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.423422437.4
2DLD Change Limit1461621426.95021030.5
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.43624030.5
 
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.