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
vapours1227745(None) 
sapours93610611sapours
valours10248731valours
vapors113812691vapo_rs
vapour11378871vapour_
vapoury15284801vapoury
amours83512642_amours
favours13437082favours
inpours936412inpours
labours9349882labours
pours74623182__pours
repours9310222repours
sapors84118812sapo_rs
sapour83812372sapour_
savours10389332savours
tabours94110072tabours
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
arbours93910033arbours
ardours8368873ardours
armours9389843armours
augurs7399963_augurs
bayous11411143bayou_s
campouts1436823campouts
candours11408613candours
canoers94318373canoers
capers105428133cap_ers
capfuls1436523capfuls
capons104119503capo_ns
capos94826073capo__s
capotes11314643capotes
capouch1644413capouch
cappers134419403cappers
captors113914983captors
capture1138903capture
captures1239433captures
clamours1255963clamours
clours85215083_clours
colours95913413colours
copouts11311073copouts
detours858033detours
devours1166643devours
dolours8438813dolours
dyvours1453183dyvours
enamours1044653enamours
faitours1134253faitours
famous11412393famou_s
favors124211403favo_rs
favour12438333favour_
flavours1434683flavours
flours94414053_flours
fours85521493__fours
gapers94520463gap_ers
gaposis1038423gaposis
gators74115823gato_rs
gaurs66317993ga__urs
giaours834563giaours
glamours1184723glamours
harbours1346903harbours
haviours1443833haviours
honours10339353honours
hours85422383__hours
humours1286413humours
inpour837063inpour_
japers154616173jap_ers
kapoks11347263kapo_ks
labors84016403labo_rs
labour84210933labour_
langurs889103langurs
lapfuls1234503lapfuls
lappers113717463lappers
lapsers93911053lapsers
lapsus8437273lapsu_s
layouts1046483layouts
lours55125293__lours
lupous849433lupou_s
mahouts1237143mahouts
majors154511093majo_rs
manors84420883mano_rs
mappers133313773mappers
mayors115714193mayo_rs
nappers114214863nappers
odours7418233_odours
ours47237563___ours
outpours1036653outpours
padouks1434863padouks
pandours11317983pandours
papers105125323pap_ers
pappous1057463pappou_s
pappus9408373pappu_s
papyrus1444063papyrus
parlours1036153parlours
parous84024163parou_s
paviours1343613paviours
payors114312643payo_rs
payouts1247303payouts
poufs105616063__poufs
pour611527473__pour_
pouts75530323__pouts
purs65641043__p_urs
ragouts838533ragouts
ramous8417103ramou_s
rancours1076703rancours
rapers84327183rap_ers
rapiers95012873rapiers
rappers113618443rappers
raptors94213353raptors
rapture937383rapture
raptures1037573raptures
razors154711653razo_rs
repour8310993repour_
rigours8206993rigours
rumours976363rumours
sajous13310583sajou_s
samburs11369343samburs
santours837173santours
santurs7310763santurs
sapor75119253sapo_r_
sapotas939603sapotas
sapotes9313933sapotes
sappers113518893sappers
saviours1154273saviours
savors95616103savo_rs
savour94110703savour_
savoury13365873savoury
scours84913583_scours
sopors85215193sopo_rs
sours55230503__sours
spoors84014023_spoors
spouts85115113_spouts
spurs74621523_sp_urs
stours65015623_stours
tabors84517093tabo_rs
tabour84011313tabour_
tambours1255863tambours
tamburs11288603tamburs
tapers84025813tap_ers
tapirs84113173tap_irs
tappers113416543tappers
tenours72610053tenours
tours55325863__tours
tumours976733tumours
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
vavasours15131883vavasours
velour9328763velour_
venous93713193venou_s
vetoers10359473vetoers
viators102712013viato_rs
vigors102911483vigo_rs
vigour10256803vigour_
vinous93914173vinou_s
vipers114914533vip_ers
visors92912223viso_rs
vizors18328903vizo_rs
vodouns1134753vodouns
vodous1038593vodou_s
voyeurs1332423voyeurs
vrouws12494743v_rouws
yapocks18354723yapocks
yapoks15346783yapo_ks
yapons114411773yapo_ns
yappers144012253yappers
yours85217873__yours
zappers203911633zappers

Search took 9 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.1401276364.3
2DLD Change Limit1340272038.72015370.1
3Display Results2032030.0762671.1
 (SQL Overall)1786912038.93619996.8
 
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.