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

209 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
chivying203497(None) 
chevying2034051chevying
chivvying2441711chivvying
chiding143911592chi_ding
childing15288502childing
chilling143512182chilling
chiming153311832chi_ming
chining133316842chi_ning
chinking183210892chinking
chinning14329652chinning
chipping18389792chipping
chirking18339382chirking
chirming16318642chirming
chirping16278862chirping
chirring142610172chirring
chitling142910662chitling
hiving134115522_hiv_ing
achieving1843303achieving
archiving1844763archiv_ing
caddying16225063caddying
calving134113503calv_ing
candying15188993candying
carrying14148373carrying
carving133916773carv_ing
caviling14310113caviling
caving124822613c_av_ing
ceiling103416723cei_ling
chaffing2036323chaffing
chafing163911493ch_afing
chaining142810783chaining
chairing143110773chairing
chalking183310063chalking
chammying2243353chammying
champing183610933champing
chancing162810283chancing
changing153211513changing
chanting143413533chanting
chapping183710723chapping
charging152910773charging
charing133721323ch_aring
charking183512613charking
charming163012033charming
charring142913163charring
charting142614193charting
chasing133715893ch_asing
chatting142810143chatting
chawing164813033ch_awing
cheating144014523cheating
checking20379203checking
cheeking18349083cheeking
cheeping16329553cheeping
cheering143612703cheering
cheesing14349413cheesing
cheffing2034463cheffing
chefing16359033ch_efing
chewing163911143ch_ewing
chicaning1745163chicaning
chiseling1536403chiseling
chitin113114963chi_tin_
chitins122713793chi_tins
chitlin12269283chitlin_
chitlings15255903chitlings
chitlins13289393chitlins
chivariing1942803chivariing
chivied16368383chiv_ied
chivies153412853chiv_ies
chivvied2052523chivvied
chivvies1954423chivvies
chivy164810363chivy___
chocking204011013chocking
choiring14279793choiring
choking173911943ch_oking
chomping18339883chomping
choosing142010133choosing
chopping183710263chopping
chording15410153chording
choring133617663ch_oring
chousing14259423chousing
chowing164412773ch_owing
chowsing17217343chowsing
chroming163410723chroming
chucking20379503chucking
chuffing2055043chuffing
chugging1634913chugging
chumming18366203chumming
chumping18349063chumping
chunking18328053chunking
churning14237173churning
churring14298653churring
chuting132910733ch_uting
citifying1845383citifying
citing94220183c_i_ting
claying133614303c_laying
clicking173610983clicking
climbing15205983climbing
clinging122910913clinging
clinking153611663clinking
clipping15349153clipping
cliquing2035363cliquing
cloying133511753c_loying
codifying1944953codifying
coiffing1755933coiffing
coifing133213893coi_fing
coigning1237173coigning
coiling103723453coi_ling
coining103920543coi_ning
collying14319543collying
conveying1838323conveying
convoying1835983convoying
cooeying1438143cooeying
copying153411983c_opying
cosying134513133c_osying
coving124321523c_ov_ing
coying124021483c__oying
cozying22308063c_ozying
craving134015733crav_ing
cribbing15276843cribbing
cricking173412653cricking
crimping15299783crimping
cringing123311383cringing
crisping13319663crisping
crying123612283c__rying
cullying14297503cullying
currying14196493currying
curving133912103curv_ing
dairying1336353dairying
deifying1637633deifying
diving113717953_div_ing
divvying1932773divvying
driving123910713driv_ing
edifying1636083edifying
envying1435713_envying
giving114313883_giv_ing
having134220373_hav_ing
haying134420613_h_aying
hiding114319333_hi_ding
hieing104216623_hi_eing
hiking143617103_hi_king
hilding123713533_hilding
hilling113821773_hilling
hilting113316893_hilting
hinging123917123_hinging
hinnying15124853_hinnying
hinting113919223_hinting
hipping153915103_hipping
hiring104421603_hi_ring
hissing114213143_hissing
histing113720373_histing
hitting113017273_hitting
hying126514743_h__ying
jiving173711603_jiv_ing
levying1435873_levying
living104318323_liv_ing
outvying1536063outvying
phonying1745833phonying
pitying132910243_pitying
reifying1539383reifying
reiving113316843reiv_ing
riving104521423_riv_ing
savvying1862723savvying
schilling15286393schilling
scriving14258763scriv_ing
shaving143414333shav_ing
shieling123512403shieling
shifting152910383shifting
shilling123315383shilling
shimming16278253shimming
shimmying2042533shimmying
shining113816523shi_ning
shinning123211023shinning
shinnying16193723shinnying
shipping163611253shipping
shirking163210473shirking
shirring122910443shirring
shirting123213613shirting
shitting123212663shitting
shivering1637333shivering
shoving142910643shov_ing
shriving15268453shriv_ing
shying134211843sh__ying
skiving15298373skiv_ing
skivvying2391603skivvying
stimying1437503stimying
swiving14358953swiv_ing
thieving1535143thieving
thinking16289863thinking
thinning12319093thinning
thirling12248583thirling
thriving15246353thriv_ing
tidying1238513_tidying
unifying1537553unifying
vying125111813___vying
waiving14329633waiv_ing
whidding1734573whidding
whiffing2134703whiffing
whiling143511743whi_ling
whinging16247743whinging
whining143311673whi_ning
whinnying19172733whinnying
whipping19328173whipping
whirling15237163whirling
whirring15286283whirring
whirrying1962733whirrying
whishing18287183whishing
whisking19286613whisking
whisting15329543whisting
whiting143311303whi_ting
whizzing2333383whizzing
wiving133316603_wiv_ing

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.420425454.8
2DLD Change Limit1461622097.26620115.9
3Display Results2092090.0762750.0
 (SQL Overall)1786912097.76223021.3
 
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.