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 “capsized” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
capsized225549(None) 
capsize2037621capsize_
capsizes2147201capsizes
baptized2245482baptized
capizes20410372cap_izes
caponized2347072caponized
capsid11312412capsi__d
capsuled1334532capsuled
capsulized2482952capsulized
upsized19246252_upsized
agnized18247223_agnized
apprized2236543apprized
apsides103911303_apsides
aspired1068173_aspired
assize1538633_assize_
assizes1638453_assizes
baptised1335263baptised
baptize2036983baptize_
baptizer2134893baptizer
baptizes2136843baptizes
basined10310003ba_sined
cabined1239993ca_bined
caddied123710563caddi_ed
caddised13315893caddised
calcined1338743calcined
calorized21249673calorized
camailed1336553camailed
campsite1447413campsite_
campsites1546473campsites
canalized21611693canalized
candied113816023candi_ed
canonized2147683canonized
caped104931803cap___ed
capered123014043cap_ered
capiz18514563cap_iz__
caponize2139113caponize_
caponizes2238703caponizes
capped134721853cap__ped
caprice1349683caprice_
caprices1439893caprices
caprine11314233caprine_
caprioled1464743caprioled
capsicin1455593capsicin
capsicum1643533capsicum
capsidal1345623capsidal
capsids1239333capsi_ds
capsizing2345833capsizing
capsomer1445773capsomer
capsule1137343capsule_
capsules1236623capsules
capsulize2293813capsulize_
capsulizes2383293capsulizes
captained1446193captained
captioned1445763captioned
captive1438973captive_
captives1538623captives
captured1336573captured
capuched1843743capuched
caried94528693ca_ri_ed
carried103717153carri_ed
cased86032413ca_s__ed
cashed125124353ca_s_hed
casked134815513ca_s_ked
casqued19235633ca_squed
cassine93817283cassine_
cassines103116613cassines
cassises103811743cassises
castled104311513ca_stled
caused95117043caus__ed
caviled1348723ca_viled
cognized2136293cognized
comprized2567223comprized
copied114618563cop_i_ed
coppiced1734823coppiced
cosied94819883c_osi_ed
cyclized2544943cyclized
daisied93410013daisi_ed
gipsied1135873gipsi_ed
gypsied1443263gypsi_ed
japanized2844733japanized
laicized2046043laicized
lapsed94712583laps__ed
lopsided1244253lopsided
midsized2144733midsized
outsized18209743outsized
palsied102911303palsi_ed
peptized22237523peptized
prized184415393__prized
resized174614903_resized
sized155519243___sized
unprized2038513unprized
unsized172510543_unsized
upsize17267303_upsize_
upsizes18297163_upsizes
vaporized24227353vaporized
varisized2244493varisized

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 Limit146162966.61022112.3
3Display Results96960.0303200.0
 (SQL Overall)178691967.06325299.6
 
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.