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

191 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
scapose114775(None) 
capos94826072_capos_
capote10315732_capote
sapote8314352s_apote
scape96921842scap__e
scapes105122262scapes_
scariose1037592scariose
secalose1046952secalose
suppose1137972suppose
acarbose1244683acarbose
acaulose1044383acaulose
acerose9310893acerose
acetose938843acetose
acinose938573acinose
adipose1036653adipose
agarose838653agarose
apos65433823__apos_
appose10411993_appose
apse67725383__ap_se
arose55832083__arose
caboose1138273_caboose
cajole154011183_cajole
callose9313653_callose
calos74431903_calos_
camise103319633_camise
camos95927613_camos_
campos125217953_campos_
canoe75627253_cano_e
canoes84725883_canoes
cape87242783_cap__e
capes95441923_capes_
caphs124515373_caphs_
capo85829213_capo__
capon95221873_capo_n
capons104119503_capons
capotes11314643_capotes
caps87147893_cap_s_
carouse9614423_carouse
carse74934333_ca_rse
case65848083_ca__se
caseose939163_caseose
cause75225353_ca_use
cayuse11207763_cayuse
choose115116143_choose
chose105925403_c_hose
close76425223_c_lose
comose105016843_comose
compose135716663compose
copse95623923_cop_se
cymose13429653_cymose
depose94215763_depose
dispose10312753dispose
elapse857523elap_se
escalope1244523escalope
escapade1343303escapade
escape103811663escap__e
escapee113310463escap_ee
escapees12336333escapees
escapes113811673escapes_
escapism1444453escapism
escapist1246213escapist
escarole1045743escarole
expose1549523_expose
impose103113043_impose
lactose969473lactose
lanose6313593_lanose
lapse74917683_lap_se
oppose1039193_oppose
papoose1147513_papoose
pappose1047413pappose
pose66441733___pose
propose112714843propose
purpose1137383purpose
ramose8314403_ramose
repose84121413_repose
sagos66123873s_agos_
samosa8510203s_amosa
sapor75119253s_apo_r
sapors84118813s_apors
sapota8310203s_apota
sapotes9313933s_apotes
sapour83812373s_apour
saprobe1137333s_aprobe
saps65346373s_ap_s_
sarode75317513s_arode
saros55238063s_aros_
saroses73619333s_aroses
scabble13168653scabble
scabies11613333scabies
scabiosa1262853scabiosa
scabs94818643sca_bs_
scads85419953sca_ds_
scags85520973sca_gs_
scalade10359263scalade
scalage103110533scalage
scalare93311833scalare
scalds94813693scalds_
scale74629143sca__le
scalene9310773scalene
scales84529313scales_
scalls84218203scalls_
scalps104315233scalps_
scampies1439323scampies
scampish1744893scampish
scamps125014173scamps_
scams94423973sca_ms_
scans74625103sca_ns_
scants85219723scants_
scaped115519553scap_ed
scaphoid1646053scaphoid
scaping123715693scaping
scapolite1346243scapolite
scapula1136343scapula
scapulae1255433scapulae
scarce104013633sca_rce
scare75334463sca__re
scares85033003scares_
scarfs114714683scarfs_
scarphs14437413scarphs_
scarps104718603scarps_
scars75433533sca_rs_
scarts85321493scarts_
scarves124511623scarves
scathe114414993sca_the
scathes124515713scathes
scats75930603sca_ts_
scatts85914663scatts_
scaups105411933scaups_
scaurs85512043scaurs_
sceptre1135043sceptre
schappe1635263schap_pe
schappes1736033schappes
schmoe13328333schmo_e
schmoes14308543schmoes
schmoose15295973schmoose
schmos13379153schmos_
sclerose1046213sclerose
scone74621833sc__one
scoops105414363scoops_
scope94821483sc__ope
scopes104719593scopes_
scops95820193scop_s_
score75526733sc__ore
scouse84113633sc_ouse
scrape105917573scrap__e
scrapes116217663scrapes_
scrapie115010943scrap_ie
scrapies124612473scrapies
scrapple1434683scrapple
scraps106017243scrap_s_
scrooge1037173scrooge
scups95316653scup_s_
seahorse1145593seahorse
seaport9315593seaport
secaloses1146903secaloses
setose65114773s_etose
shakoes144510013shakoes
shakos134912183shakos_
shamos114216983shamos_
shape105125113shap__e
shapes115124943shapes_
siamese936503siamese
skatole1135683skatole
slaps76025713slap_s_
snaps74719563snap_s_
soaps75120713soap_s_
sorbose938983sorbose
sparse84516343spa_rse
spathose1345623spathose
spinose937943spinose
spode84617703s__pode
spoke114818663s__poke
spore75428593s__pore
spouse84112513s__pouse
squamose1944273squamose
stapes85028733stapes_
staphs114411033staphs_
staple84415823stap_le
staples93617213staples
starnose8136683starnose
sucralose1193713sucralose
sucrose939303sucrose
supposed1345783supposed
supposer1245593supposer
supposes1238203supposes
swaps104819203swap_s_
sycamore1542763sycamore
synapse1234133synap_se
trappose1245813trappose
vadose1037963_vadose
vamose1159283_vamose

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 Filter1786911340270.220812231.8
2DLD Change Limit1340271917.56317721.4
3Display Results1911910.0633031.7
 (SQL Overall)1786911917.84622774.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.