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

235 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
sowcars123600(None) 
soucars938411soucars
sowars94318001sow_ars
sowcar1135861sowcar_
boxcars1834772boxcars
jowars16369652jow_ars
scars75433532s__cars
sewars94018622sew_ars
snowcaps1542692snowcaps
snowcats1343402snowcats
soars54732512so__ars
socas74026182so_ca_s
soccers1138392soccers
sofars94712782so_fars
sonars64818972so_nars
soucar839322soucar_
sowans94215892sow_ans
sowar85821342sow_ar_
sowers94923432sow_ers
swears94114072s_wears
boars75229603bo__ars
bobcats1335993bobcats
bowers115523703bow_ers
bowlers123715783bowlers
bowyers15438733bowyers
boxcar1734753boxcar_
boyars115611983bo_yars
calcars11312653calcars
cars67364763___cars
cocas95926573co_ca_s
collars93816573collars
concurs11311453concurs
costars94217993costars
cottars94412233cottars
cougars1038423cougars
coward12411673cow_ard
cowards1339613cow_ards
cowers114625533cow_ers
cowpats1437713cowpats
crowbars1544423crowbars
dewars105117073dew_ars
dogcart1148043dogcart
dogcarts1243883dogcarts
dogears937513dogears
dollars83311023dollars
dowers104523293dow_ers
downers113912773downers
dowsers115013523dowsers
escars83913133_escars
forcers124215713forcers
fowlers133411203fowlers
gowans105512293gow_ans
hoars85925543ho__ars
howdahs1733613howdahs
howlers133312353howlers
isobars936573iso_bars
jowar155211433jow_ar_
lascars979013lascars
locals83714503lo_cals
lowers94624923low_ers
mobcaps1543463mobcaps
molars85517323mo_lars
mortars93411523mortars
mowers113219403mow_ers
nonwars10109003nonwars
noways12127733now_ays
oars46846033_o__ars
ocas66729633_o_ca_s
occurs10136553_occurs
orcas75918623_orca_s
ottars64112223_ottars
owners94210703_owners
oxcart1539523_oxcart
oxcarts1634313_oxcarts
polars84419353po_lars
poplars113910333poplars
powders134111553powders
powers113822323pow_ers
powters124015653powters
psywars1533673psyw_ars
rewears102911033rewears
roars55622233ro__ars
rowans95715343row_ans
rowers94924573row_ers
saggars93610683saggars
sambars115113843sambars
sangars83116253sangars
sansars73313913sansars
sardars83112903sardars
sarsars73512143sarsars
saucers93712133saucers
sawers94620163saw_ers
sawyers13317533sawyers
scabs94818643s__cabs
scads85419953s__cads
scags85520973s__cags
scalars93711903scalars
scams94423973s__cams
scans74625103s__cans
scar66434203s__car_
scare75334463s__care
scares85033003s__cares
scarf105427143s__carf
scarfs114714683s__carfs
scarp95724103s__carp
scarps104718603s__carps
scart76139773s__cart
scarts85321493s__carts
scary105222593s__cary
scats75930603s__cats
scaurs85512043s__caurs
scowders14276213scowders
scowlers13257343scowlers
sears54744913s__ears
secpars1138413secpars
seggars9377783seggars
sewans95215903sew_ans
sewar85421093sew_ar_
sewers94719713sew_ers
shears93820903s_hears
shikars1436183shikars
shmears1277073shmears
shofars1335813shofars
shophars1646353shophars
showcase1643123showcase
showcases1743323showcases
showers134612663show_ers
shwas116415103shw_a_s
sidecars1145903sidecars
simars84916933s_imars
sirdars8228213sirdars
sitars65417593s_itars
sizars154812623s_izars
skycaps1842703skycaps
slicers94114923slicers
smears84714433s_mears
snowcap1442823snowca_p
snowcat1245333snowca_t
soakers114114953soakers
soaks95220293so__aks
soapers93715923soapers
soaps75120713so__aps
soar46838673so__ar_
soarers74118093soarers
sobas74424253so_ba_s
sobbers114114253sobbers
sobers85218853so_bers
soca66330053so_ca__
socage91012123so_cage
socagers1196363so_cagers
socages101012053so_cages
soccage1236283soccage
soccages1336383soccages
soccer1038543soccer_
socials999633socials
socks114926083so_c_ks
socles8418453so_cles
sodas64123543so_da_s
sofar86115493so_far_
sofas85320713so_fa_s
softas94410403softa_s
sojas124716393so_ja_s
solacers10268893solacers
solaces93116133solaces
solans64122493so_lans
solar55927343so_lar_
soldans83210403soldans
solders83517773solders
solvers104414253solvers
somans84619303so_mans
somas76030373so_ma_s
sonar56523423so_nar_
sonders83820713sonders
sooners73916643sooners
sopors85215193so_pors
soras55041013so_ra_s
sorcery1237023sorcery
sordors839983sordors
sorners73416863sorners
sorters74221113sorters
souari6311373so_uari
souaris7312323so_uaris
soudans8309353soudans
sours55230503so__urs
souters74422583souters
sovrans1036483sovrans
sowens93613153sow_ens
sower85229313sow_er_
sows75342493sow___s
soyas84520913so_ya_s
spacers113813873spacers
spars75431543s__pars
spears84019473s_pears
spicas104715823spica_s
spicers113815553spicers
stars55836573s__tars
stockcars1742973stockcars
succahs1435323succahs
succors1137413succors
sugars7312423s_ugars
swabs105817273s_w_abs
swags94921253s_w_ags
swans84625013s_w_ans
swaps104819203s_w_aps
sward94221463s_w_ard
swards105415133s_w_ards
sware85828213s_w_are
swarf115324653s_w_arf
swarfs125612063s_w_arfs
swarm106218833s_w_arm
swarms116112163s_w_arms
swart86234643s_w_art
swats85726863s_w_ats
sways115518463s_w_ays
swear85316853s_wear_
sweats94814613s_weats
syncarp1444533syncarp
syncarps1543903syncarps
toecaps1135553toecaps
tolars64817923to_lars
tomcats11127773tomcats
toucans937573toucans
toward10311063tow_ard
towards1138783tow_ards
towers94423673tow_ers
trocars959023trocars
vicars11712263_vicars
vocabs13336313vo_cabs
vocals113811583vo_cals
voicers12348993voicers
vowers124317183vow_ers
wars78659803__w_ars
wears86030303__wears
wowsers13488753wowsers
yowlers13328923yowlers

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.1431249587.4
2DLD Change Limit1340272358.32616097.4
3Display Results2352350.0932526.9
 (SQL Overall)1786912358.56220870.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.