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

203 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
vapours1227746(None) 
sapours93610621sapours
valours10248741valours
vapors113812691vapo_rs
vapour11378871vapour_
vapoury15284801vapoury
amours83512662_amours
favours13437092favours
inpours936422inpours
labours9349892labours
pours74623182__pours
repours9310232repours
sapors84118812sapo_rs
sapour83812372sapour_
savours10389342savours
tabours94110092tabours
valors93413772valo_rs
valour93010372valour_
vapor104013092vapo_r_
vaporers1336242vaporers
vapory14398762vapo_ry
vapoured1434352vapoured
vapourer1344262vapourer
vapourers1443372vapourers
velours10278082velours
vigours11285482vigours
amour75014853_amour_
apers76629133_ap_ers
apods86316343_apo_ds
aport75432173_apo_rt
apos65433823_apo__s
arbours93910043arbours
ardours8368883ardours
armours9389853armours
augurs7399963_augurs
bayous11411153bayou_s
campouts1436823campouts
candours11408643candours
canoers94318373canoers
capers105428143cap_ers
capfuls1436523capfuls
capons104119503capo_ns
capos94826073capo__s
capotes11314643capotes
capouch1644413capouch
cappers134419403cappers
captors113914983captors
capture1138913capture
captures1239443captures
clamours1255993clamours
clours85215093_clours
colours95913443colours
copouts11311083copouts
detours858043detours
devours1166643devours
dolours8438823dolours
dyvours1453183dyvours
enamours1044663enamours
faitours1134263faitours
famous11412393famou_s
favors124211403favo_rs
favour12438333favour_
flavours1434693flavours
flours94414053_flours
fours85521493__fours
gapers94520473gap_ers
gaposis1038423gaposis
gators74115843gato_rs
gaurs66317993ga__urs
giaours834573giaours
glamours1184743glamours
harbours1346923harbours
haviours1443843haviours
honours10339373honours
hours85422393__hours
humours1286433humours
inpour837063inpour_
japers154616173jap_ers
kapoks11347263kapo_ks
labors84016413labo_rs
labour84210933labour_
langurs889103langurs
lapfuls1234503lapfuls
lappers113717463lappers
lapsers93911053lapsers
lapsus8437273lapsu_s
layouts1046483layouts
lours55125293__lours
lupous849433lupou_s
mahouts1237143mahouts
majors154511093majo_rs
manors84420883mano_rs
mappers133313783mappers
mayors115714193mayo_rs
nappers114214863nappers
odours7418253_odours
ours47237563___ours
outpours1036683outpours
padouks1434873padouks
pandours11317993pandours
papers105125323pap_ers
pappous1057463pappou_s
pappus9408373pappu_s
papyrus1444063papyrus
parlours1036153parlours
parous84024163parou_s
paviours1343613paviours
payors114312643payo_rs
payouts1247303payouts
poufs105616063__poufs
pour611527473__pour_
pouts75530323__pouts
purs65641043__p_urs
ragouts838543ragouts
ramous8417113ramou_s
rancours1076713rancours
rapers84327183rap_ers
rapiers95012873rapiers
rappers113618443rappers
raptors94213353raptors
rapture937393rapture
raptures1037583raptures
razors154711663razo_rs
repour8310993repour_
rigours8207003rigours
rumours976373rumours
sajous13310583sajou_s
samburs11369343samburs
santours837183santours
santurs7310763santurs
sapor75119253sapo_r_
sapotas939613sapotas
sapotes9313943sapotes
sappers113518903sappers
saviours1154273saviours
savors95616103savo_rs
savour94110703savour_
savoury13365873savoury
scours84913593_scours
sopors85215203sopo_rs
sours55230503__sours
spoors84014033_spoors
spouts85115113_spouts
spurs74621523_sp_urs
stours65015633_stours
tabors84517113tabo_rs
tabour84011323tabour_
tambours1255873tambours
tamburs11288613tamburs
tapers84025813tap_ers
tapirs84113173tap_irs
tappers113416543tappers
tenours72610073tenours
tours55325893__tours
tumours976753tumours
vacuous1237023vacuous
vacuums1443403vacuums
vagus96713813va_gu_s
vairs85019133va__irs
valgus1047103valgu_s
valkyrs1732163valkyrs
valor83614893valo_r_
valuers10328943valuers
values94314943va_lues
vamoses1239143vamoses
vampers143111623vampers
vanners103612843vanners
vanpools1343193vanpools
vapored1336923vapored
vaporer1236983vaporer
vaporise13209633vaporise
vaporish16246733vaporish
vaporous1346483vaporous
vapouring1544653vapouring
variers103712663variers
various103113103variou_s
varooms1248883varooms
vars75742073va___rs
varus85921183va_ru_s
vatfuls1384853vatfuls
vatus86114643va_tu_s
vaus75928923va__u_s
vavasours15131893vavasours
velour9328763velour_
venous93713193venou_s
vetoers10359473vetoers
viators102712023viato_rs
vigors102911483vigo_rs
vigour10256803vigour_
vinous93914173vinou_s
vipers114914533vip_ers
visors92912223viso_rs
vizors18328903vizo_rs
vodouns1134763vodouns
vodous1038603vodou_s
voyeurs1332423voyeurs
vrouws12494743v_rouws
yapocks18354723yapocks
yapoks15346783yapo_ks
yapons114411773yapo_ns
yappers144012253yappers
yours85217883__yours
zappers203911633zappers

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272035.95322514.2
3Display Results2032030.0762671.1
 (SQL Overall)1786912036.43527768.6
 
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.