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

338 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
sapours9361062(None) 
sapors84118811sapo_rs
sapour83812371sapour_
savours10389341savours
vapours12277461vapours
amours83512662_amours
favours13437092favours
inpours936422inpours
labours9349892labours
pours74623182__pours
repours9310232repours
sajous13310582sajou_s
samburs11369342samburs
santours837182santours
santurs7310762santurs
sapor75119252sapo_r_
sapotas939612sapotas
sapotes9313942sapotes
sappers113518902sappers
saviours1154272saviours
savors95616102savo_rs
savour94110702savour_
savoury13365872savoury
scours84913592s_cours
sopors85215202sopo_rs
sours55230502s__ours
spoors84014032s_poors
spouts85115112s_pouts
spurs74621522s_p_urs
stours65015632s_tours
tabours94110092tabours
valours10248742valours
vapors113812692vapo_rs
vapour11378872vapour_
vapoury15284802vapoury
amour75014853_amour_
apers76629133_ap_ers
apods86316343_apo_ds
aport75432173_apo_rt
apos65433823_apo__s
arbours93910043arbours
ardours8368883ardours
armours9389853armours
aspers86220313asp_ers
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
gators74115833gato_rs
gaurs66317993ga__urs
giaours834573giaours
glamours1184733glamours
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
rapture937383rapture
raptures1037573raptures
razors154711663razo_rs
repour8310993repour_
rigours8207003rigours
rumours976373rumours
sabers85224733sa_bers
sabirs85414633sa_birs
saboteurs1141863saboteurs
sabots8314703sabo_ts
sacbuts1166473sacbuts
sackers133820223sackers
sacques18106863sacques
sacrums11388043sacrums
sadhus10298463sadhu_s
sagbuts1065223sagbuts
saggars93610683saggars
saggers94017083saggers
sagos66123873sago__s
sailers73822323sailers
sailors73213723sailors
sajou12311693sajou__
sakers104125433sa_kers
salols64017873salo_ls
salons63823693salo_ns
saloons74415323saloons
saloops93510133saloops
salters73622253salters
salvers103916003salvers
salvors103910913salvors
sambars115113843sambars
sambhurs1543183sambhurs
sambur10469503sambur_
samosas939293samosas
samovars1343703samovars
samplers12299403samplers
sandburs11105623sandburs
sanders84025943sanders
sangars83116253sangars
sangers84421943sangers
sanious7514103saniou_s
sannups934463sannups
sansars73313913sansars
santirs7312963santirs
santoors837633santoors
santour737373santour_
santur6311273santur_
sapajous1744833sapajou_s
sapiens9310173sapiens
sapless93313443sapless
saponin9310263saponin
saponins1039453saponins
saporous1039053saporous
sapota8310213sapo_ta
sapote8314363sapo_te
sapper103822353sapper_
saprobes1237033saprobes
saps65346373sap___s
sapwoods1456263sapwoods
sarcous9312933sarcou_s
sardars83112903sardars
sarodes84216143sarodes
sarods74918573saro_ds
sarongs84511803sarongs
saros55238063saro__s
saroses73619333saroses
sarsars73512143sarsars
sartors7314973sartors
satori6415843sato_ri
satoris7317253satoris
satyrs937963sa_tyrs
saucers93712133saucers
saugers83914053saugers
sauls55128123sa__uls
saury84317223sa__ury
sautoirs834923sautoirs
savers93825923sa_vers
saviors1058993saviors
saviour1035213saviour_
savor85417943savo_r_
savorers1157223savorers
savory124310563savo_ry
savoured1234793savoured
savourer1134473savourer
savourers1243833savourers
savouries1245473savouries
savoys12427893savo_ys
sawers94620163sa_wers
sawyers13317533sawyers
sayers94221593sa_yers
scaurs85512053s_caurs
scour75315533s_cour_
scouts84817943s_couts
seaport9315603seapo_rt
seaports1038463seaports
senors63620793seno_rs
sepoys1138473sepo_ys
septums1135743septums
serous65023563serou_s
setous64917373setou_s
setouts74110333setouts
shapers124016893shap_ers
shapeups1542723shapeups
shoers94518333s_hoers
shouts94017723s_houts
shrouds1136023shrouds
siddurs934173siddurs
sieurs659043s_ieurs
sippers113117753sippers
slappers123710943slappers
slipouts1044893slipouts
slopers94213093slopers
slurs54123373s__lurs
snappers123510173snappers
snouts64915873s_nouts
soapers93715923soap_ers
soapsuds1141973soapsuds
soars54732513s__oars
sojourn1442893sojourn
sojourns1542313sojourns
sopor74016493sopo_r_
sorus54527583s__orus
souks94820523s__ouks
souls55127363s__ouls
soups75322943s__oups
sour45935893s__our_
sous46947213s__ou_s
spacers113813873spacers
spaders104214473spaders
sparers94519613sparers
spars75431543s_p_ars
spears84019473s_pears
speers85019953s_peers
speirs85013233s_peirs
spiers84421743s_piers
spodes94817433s_podes
spoils84614533s_poils
spokes124417213s_pokes
spoofs114011813s_poofs
spooks124312933s_pooks
spools85115913s_pools
spoons84116023s_poons
spoor75016353s_poor_
spore75428593s_po_re
spores84726613s_pores
sport75935983s_po_rt
sports84619183s_ports
spots74424113s_po_ts
spouse84112513s_pouse
spouses92912813s_pouses
spout75029633s_pou_t
spouters104011163s_pouters
sprouts949983sprouts
sprues84515763s_prues
sprugs94010173s_prugs
spuds85113673s_p_uds
spues75025383s_p_ues
spur65321193s_p_ur_
spurn74815453s_p_urn
spurns84811383s_p_urns
spurt77227983s_p_urt
spurts84814973s_p_urts
staplers103111203staplers
stators73915583stato_rs
stopers94217373stopers
stoups85313273s_toups
stour54916743s_tour_
stoure64814943s_toure
stoures74614163s_toures
stoury9529943s_toury
stouts65019003s_touts
strouds837803strouds
stupors935883stupo_rs
succours1244593succours
sudors7311103sudo_rs
sulfurs1037343sulfurs
sulphurs1383653sulphurs
supers84622403sup_ers
suppers113314703suppers
swappers15358083swappers
swouns9358243s_wouns
syphers15317273syphers
tabors84517113tabo_rs
tabour84011323tabour_
tambours1255873tambours
tamburs11288613tamburs
tapers84025813tap_ers
tapirs84113173tap_irs
tappers113416543tappers
tenours72610073tenours
tours55325893__tours
tumours976753tumours
valors93413773valo_rs
valour93010373valour_
vapor104013093vapo_r_
vaporers1336243vaporers
vapory14398763vapo_ry
vapoured1434353vapoured
vapourer1344263vapourer
vapourers1443373vapourers
velours10278083velours
vigours11285483vigours
yapocks18354723yapocks
yapoks15346783yapo_ks
yapons114411773yapo_ns
yappers144012253yappers
yours85217883__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.403443402.0
2DLD Change Limit1340273387.83017117.1
3Display Results3383380.2331450.6
 (SQL Overall)1786913388.46621106.9
 
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.