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

179 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
capsizes214720(None) 
capizes20410371cap_izes
capsize2037621capsize_
capsized2255501capsized
apsides103911302_apsides
assizes1638452_assizes
baptizes2136842baptizes
campsites1546472campsites
caponizes2238702caponizes
caprices1439892caprices
capsids1239332capsi_ds
capsules1236622capsules
capsulizes2383292capsulizes
captives1538622captives
cassines103116612cassines
cassises103811742cassises
upsizes18297162_upsizes
agnizes17328843_agnizes
alsikes1137263_alsikes
aphides134711203_aphides
apices104916263_ap_ices
aplites9314933_aplites
apprizes2137793apprizes
apses76823913_aps__es
apsis75718293_apsi__s
arsines73518823_arsines
asides75118873_a_sides
aspires9612043_aspires
aspises9611643_aspises
assize1538633_assize_
baizes174315053ba__izes
baptises1238923baptises
baptize2036983baptize_
baptized2245483baptized
baptizer2134893baptizer
baptizers2243443baptizers
cabbies133115163cabbi_es
caddices14297853caddices
caddies113718383caddi_es
caddises12329353caddises
caesiums1245533caesiums
calcines12314753calcines
calcites12313003calcites
calices114321693ca_lices
calorizes202312303calorizes
camises114218463ca_mises
cammies134016483cammi_es
campfires1844123campfires
camphines1847563camphines
camphires1845783camphires
campsite1447413campsite_
canalizes201113783canalizes
candies104125613candi_es
canines93724033ca_nines
canonizes2049593canonizes
capes95441923cap___es
capias10318353cap_i_as
capiases1239253capiases
capiz18514563cap_iz__
caplins113515993capli_ns
caponize2139113caponize_
caponized2347073caponized
capotes11314643cap_otes
cappings15369493cappings
caprice1349683caprice_
caprine11314233caprine_
caprioles1376753caprioles
capris10415083capri__s
capsicin1455593capsicin
capsicins1545173capsicins
capsicum1643533capsicum
capsicums1742383capsicums
capsid11312423capsi__d
capsidal1345623capsidal
capsizing2345833capsizing
capsomer1445773capsomer
capsomers1544753capsomers
capstans1257243capstans
capstones1347373capstones
capsule1137343capsule_
capsuled1334533capsuled
capsulize2293813capsulize_
capsulized2482953capsulized
captions123813223captions
captious122810573captious
captive1438973captive_
captures1239443captures
capuches1735513capuches
carbides133111693carbides
carbines123617543carbines
caribes113715643ca_ribes
carices114220953ca_rices
caries85147623ca_ri_es
carlines103521653carlines
carmines123617873carmines
carnies94123963carni_es
carries94328013carri_es
carses85233653cars__es
cases75048383ca_s__es
cashes114729883ca_s_hes
casings104013513ca_sings
casinos93512833ca_sinos
casitas93312043ca_sitas
casques18278983ca_sques
cassenes103611293cassenes
cassias93514343cassi_as
cassinas103610643cassinas
cassine93817283cassine_
cassinos10309353cassinos
cassis84818853cassi__s
castes85631863ca_s_tes
castles94917733ca_stles
catties94023053catti_es
caudices13337343caudices
causes88026473caus__es
cavies114525003ca_vi_es
chappies172610103chappi_es
cissies94116153cissi_es
coesites101313093coesites
cognizes2058033cognizes
comprizes2468943comprizes
copies104130313cop_i_es
coppices1638243coppices
copses104922483cops__es
cosies84932163c_osi_es
cosines94122673c_osines
crappies142911173crappi_es
cuisines1049373cuisines
cuprites1259023cuprites
cursives1337103cursives
cuspides13306943cuspides
cyclizes2445523cyclizes
daisies84217093daisi_es
dapsones1138383dapsones
dassies84418663dassi_es
daysides1335963daysides
depsides1238503depsides
easies64126633ea_si_es
emprizes2138133emprizes
falsies103515013falsi_es
farsides1237993farsides
gaposises1245523gaposises
gipsies1039903gipsi_es
gypsies1335953gypsi_es
hafizes2235983ha_fizes
haplites1339993haplites
japanizes2745163japanizes
laicizes1937403laicizes
lapides103012043lap_ides
lapises93513463lap_ises
lapses85217693laps__es
lassies74420103lassi_es
maizes175115733ma__izes
nappies114613403nappi_es
outsizes172311083outsizes
palsies94420273palsi_es
pansies94521983pansi_es
pappies103214833pappi_es
passives13228823passives
patsies93919483patsi_es
pepsines1239883pepsines
peptizes21269853peptizes
phizes20389133__phizes
popsies112816473popsi_es
prizes173819813__prizes
raphides14188393raphides
rapines95120863rap_ines
resizes164216843_resizes
sassies74719263sassi_es
sizes146727763___sizes
tansies74521243tansi_es
tapises92914013tap_ises
tassies74918933tassi_es
topsides1137203topsides
upsides10319633_upsides
upsize17267303_upsize_
upsized19246253_upsized
vaporizes23228523vaporizes
waysides1544453waysides

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621796.59322169.3
3Display Results1791790.0632841.3
 (SQL Overall)1786911797.07925242.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.