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

108 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
vapoured143435(None) 
vapored1336921vapo_red
vapourer1344261vapourer
captured1336562captured
favoured1533962favoured
inpoured1135812inpoured
laboured1156322laboured
poured95116742__poured
raptured1155462raptured
repoured1139562repoured
savoured1234792savoured
taboured1156272taboured
vaporer1236982vapo_rer
vapour11378872vapour__
vapourers1443372vapourers
vapours12277452vapour_s
vapoury15284802vapour_y
abjured1735073_abjured
adjured1634873_adjured
adored84714233_ado_red
allured8299173_allured
arboured1156253arboured
armoured1165223armoured
aroused84914343_aroused
assured858373_assured
augured987193_augured
capered123014043cap_ered
capsuled1334533capsuled
capture1138903capture_
capturer1246083capturer
captures1239433captures
caroused1149253caroused
clamoured1444063clamoured
cloured103111543_cloured
coloured1148303coloured
detoured1036513detoured
devoured1335723devoured
enamoured1243933enamoured
espoused1134853espoused
favored1455983favo_red
favourer1443823favourer
flavoured1642973flavoured
floured11289873_floured
glamoured1343183glamoured
hachured1744393hachured
harboured1544313harboured
honoured1236313honoured
humoured1444363humoured
labored102810243labo_red
labourer1045753labourer
lappered13288213lappered
loured74617403__loured
majored1735853majo_red
manured1039473ma_nured
matured10310033ma_tured
natured838963na_tured
outpoured1246013outpoured
papered122513163pap_ered
pastured1138233pastured
pored85234513__po_red
poufed12449713__poufed
pourer84516043__pourer
pouted94021393__pouted
ragouted1034423ragouted
rancoured1244693rancoured
rapiered1136053rapiered
rapture937383rapture_
raptures1037573raptures
razored1736333razo_red
rumoured1143783rumoured
ruptured1144683ruptured
sapour83812373sapour__
sapours93610613sapour_s
savored1158343savo_red
savourer1134473savourer
scoured103811153_scoured
soured74921863__soured
spoored104411293_spoored
spored94821793_spo_red
spoused10349653_spoused
spouted103412263_spouted
tabored102810563tabo_red
tabourer1035743tabourer
tabouret1049173tabouret
tamboured1443783tamboured
tapered102612933tap_ered
toured74216153__toured
unsoured9310053unsoured
vacuumed1641593vacuumed
valour93010373valour__
valours10248733valour_s
valued104011153va_lu_ed
vamoosed1443923vamoosed
vamosed1335923vamo_sed
vapor104013093vapo_r__
vaporers1336243vapo_rers
vaporised15216953vaporised
vaporized24227353vaporized
vapors113812693vapo_r_s
vapory14398763vapo_r_y
vapouring1544653vapouring
varoomed1445293varoomed
velured1136683v_elured
ventured1238273ventured
verdured13255763verdured
vestured1237463vestured
visored1138143viso_red
vizored2034133vizo_red

Search took 10 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.330541487.9
2DLD Change Limit1461621088.75016704.2
3Display Results1081080.0303600.0
 (SQL Overall)1786911089.11019614.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.