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

119 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
saprobe113733(None) 
saprobes1237031saprobes
aerobe8412402_aerobe
probe94320812__probe
reprobe112310132reprobe
safrole1037252safrole
sapote8314362sap_ote
saprobic1445262saprobic
sapropel1244642sapropel
sarode75317512sa_rode
strobe84513812s_trobe
adobe84814713_a_dobe
aerobes9311493_aerobes
anaerobe1044823anaerobe
appose10411993_appose
approve14116603approve
apron7318833_apro_n
aproned10311503_aproned
aprons8316993_aprons
arose55832083_a_rose
arroba898663_arroba
ascribe1147743ascribe
barbe95328283ba_r_be
bathrobe1544413bathrobe
capote10315733cap_ote
caprice1349683caprice
caprine11314233caprine
capriole1276913capriole
caprock1736813caprock
caribe103416753ca_ribe
carob95325223ca_rob_
carobs104818103ca_robs
dapsone1038463dapsone
disrobe1038993disrobe
earlobe946543earlobe
enrobe86610793_enrobe
garote7717953ga_rote
garrote8510103garrote
geoprobe1343823geoprobe
hagrode1236443hagrode
improve1435963improve
ladrone83611873ladrone
leprose938543leprose
madrone102812663madrone
manrope1138033manrope
microbe1338663microbe
naproxen1743203naproxen
padrone102512073padrone
papoose1147513papoose
pappose1047413pappose
parole84425253pa_role
probed114114823__probed
prober104516073__prober
probes104119453__probes
prole74527793__prole
prone75332623__prone
prose75835123__prose
prove104823193__prove
reprobed13228743reprobed
reprobes121910293reprobes
reprove122911073reprove
robe65335643___robe
sabe66140573sa___be
sabre74821503sabr__e
safrol937283safro_l
safroles1136933safroles
safrols1036863safrols
sapor75119253sap_o_r
saporous1039053saporous
sapors84118813sap_ors
sapota8310213sap_ota
sapotes9313943sap_otes
sapour83812373sap_our
saprobial1344373saprobial
saprolite1147833saprolite
sapropels1343643sapropels
sapwood1366913sapwood
sarape84817573sa_rape
saree55044663sa_r_ee
sarge65531133sa_r_ge
sarod65325873sa_ro_d
sarodes84216143sa_rodes
sarods74918573sa_rods
sarong73914873sa_rong
saros55238063sa_ro_s
saroses73619333sa_roses
scapose1147753scap_ose
scribe104613533s_cribe
seadrome1146513seadrome
shrove125412233s_hrove
sparable121611983sparable
spare75135563spar__e
sparge94216053spar_ge
sparkle133710213sparkle
sparoid102311543sparoid
sparse84516343spar_se
splore81611303s_plore
spode84617703s_p_ode
spoke114818663s_p_oke
spore75428593s_p_ore
spree74830863s_pr_ee
sprite84421773s_prite
sprout8419403s_prout
spruce103910873s_pruce
sprue74717633s_pr_ue
strobes93813263s_trobes
strode75215973s_trode
stroke105116173s_troke
strove95014793s_trove
sucrose939303sucrose
suppose1137973suppose
supreme1137893supreme
taphole1239773taphole
taproom1147963taproom
taproot9412673taproot
unprobed1366973unprobed
unrobe82611673_unrobe
uprose82311483_uprose
wardrobe1464133wardrobe

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.406440125.6
2DLD Change Limit1340271196.68620045.9
3Display Results1191190.0333606.1
 (SQL Overall)1786911197.12525079.4
 
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.