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

229 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
scalage10311053(None) 
scalade10359261scalade
scalages113010251scalages
scalare93311831scalare
escalade1144382escalade
escalate1039322escalate
salvage1138192s_alvage
savage10410172s_avage
scalable121710232scalable
scalades11258802scalades
scalado10276472scalado
scalar83612432scala_r
scalares103210982scalares
scalars93711902scalars
scale74629142scal__e
scalene9310772scalene
scutage1036332scutage
silage72715302s_ilage
smallage1145182smallage
soakage1236102soakage
soilage8169352soilage
stalag7310022stalag_
stalags838642stalags
stealage946582stealage
sullage859912sullage
acreage1037833acreage
acylate12310533acylate
adage7414053__adage
alae45643753__ala_e
alane56135613__alane
alate55340323__alate
algae65319623__algae
anlage72514223_anlage
apanage1036803apanage
cabbage1446983_cabbage
cadge94018783_ca_dge
cage75339063_c__age
calami10313423_calami
calash11312433_calash
callee84327293_callee
calque17289843_calque
calve105919923_cal_ve
canape10913513_canape
carafe115416163_carafe
carate84734003_carate
carnage10311743_carnage
cartage10312593_cartage
clade85821013_c_lade
clag75924573_c_lag_
clags85621123_c_lags
clave105420153_c_lave
collage102813753collage
cowage12310663_cowage
cubage1178273_cubage
damage10410773_damage
dealate83617843dealate
diallage1045233diallage
drayage1234423drayage
ecotage1036883ecotage
escaladed1343423escaladed
escalader1243233escalader
escalades1244403escalades
escalated1247303escalated
escalates1148823escalates
escalope1244523escalope
escapade1343303escapade
escuage1035113esc_uage
galago838903_galago
garage8314513_garage
gavage1137193_gavage
haulage1136913haulage
haylage1436443haylage
keelage1236183keelage
lavage1038263_lavage
leafage1194573leafage
leakage1235003leakage
malate84624553_malate
manage93818903_manage
milage93414123_milage
millage103112743millage
moulage1037903moulage
mucilage1344203mucilage
osculate101010613osculate
oxalate1457623oxalate
package16128013package
palace104516913_palace
palate84226783_palate
pelage9515363_pelage
phalange1465193phalange
pillage103412593pillage
plage84520403__plage
quayage2044573quayage
ravage1039303_ravage
saccade12107033saccade
saccate111311763saccate
saclike131210123saclike
sage55044593s___age
salaam8711013s_alaam
salable91415463s_alable
salad65321833s_ala_d
salads75316963s_alads
salal55425703s_ala_l
salals65120083s_alals
salami8313103s_alami
salary9515213s_alary
sale44959703s_al__e
saline65132703s_aline
salpae84614273s_alpae
saltie63422423s_altie
salute64418023s_alute
salvaged1335353s_alvaged
salvagee1246483s_alvagee
salvager1235593s_alvager
salvages1238123s_alvages
salve85022133s_al_ve
sarape84817573s_arape
sarge65531133s_a_rge
sausage847193sausage
savaged1236993s_avaged
savager1137133s_avager
savages1139973s_avages
savate9313783s_avate
scabble13168653scabble
scabland1344293scabland
scablike1635553scablike
scag76626893sc__ag_
scags85520973sc__ags
scalably15166703scalably
scalados11276083scalados
scalawag14142773scalawag
scalawags15152453scalawags
scald84818123scal__d
scalded11409763scalded
scaldic1235943scaldic
scalds94813693scal_ds
scaled94822443scal_ed
scaleni936883scaleni
scaler84321603scal_er
scalers93817263scalers
scales84529313scal_es
scaleup1134483scaleup
scalier94316913scalier
scaling103519373scaling
scall74420373scal__l
scallop11237643scallop
scalls84218203scal_ls
scalp95217983scal__p
scalped124411993scalped
scalpel11377713scalpel
scalper113912923scalper
scalps104315233scal_ps
scaly104718723scal__y
scape96921843sc__ape
scapose1147753scapose
scapulae1255433scapula_e
scarab10310063scara_b
scarabs1137293scarabs
scarce104013633sca_rce
scare75334463sc__are
scathe114414993sca_the
scavenge1442813scavenge
sclaff1438313sc_laff
scourge1035653scourge
scrag85916173sc_rag_
scrags95713803sc_rags
scrape105917573sc_rape
scrappage1642443scrappage
scrooge1037173scrooge
scrouge1036353scrouge
scutages1136503scutages
scutate9310323scutate
seabag938473seabag_
seabags1037483seabags
sealable101512693sealable
sealant73118303sealant
seaplane1049163seaplane
seaware1049623seaware
secalose1046963secalose
seepage1037543seepage
selvage1136553selvage
septage1078403septage
serfage1138403serfage
sewage10310733s_ewage
shale85332833shal__e
signage937773signage
silages82514443s_ilages
silane62718053s_ilane
sinkage1287263sinkage
slag55934353s__lag_
slags66525903s__lags
slake93724053s__lake
slate55438283s__late
slave84224033s__lave
smallages1245293smallages
smaragd1134393smaragd
smaragde1242833smaragde
soakages1336143soakages
socage91012123s_ocage
soccage1236283soccage
soilages9189673soilages
solace83415823s_olace
solate64526073s_olate
spale74929213spal__e
sparge94216043spa_rge
spillage1146263spillage
spinage10289653spinage
splake1259783s_plake
spoilage11195373spoilage
stage65330193s__tage
stale55637103stal__e
stealages1046043stealages
stelae63716483stela_e
storage8310473storage
stowage1136703stowage
stravage1245563stravage
stylate10179773stylate
sublate9315363sublate
sullages939973sullages
swage94919563s__wage
swale85221593swal__e
tallage82712073tallage
thanage11117943thanage
tillage83111333tillage
tollage82610163tollage
ullage739043_ullage
vassalage1342153vassalage
vicarage1444433vicarage
village113610823village
vorlage1136403vorlage

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.236757165.3
2DLD Change Limit1340272298.37316007.0
3Display Results2292290.0802862.5
 (SQL Overall)1786912298.68920565.2
 
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.