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

141 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
suavity133632(None) 
cavity14310012_cavity
duality1147972duality
gravity1437182gravity
quality1938562quality
sanity9316202s_anity
suavely1376492suavely
subcavity1943372subcavity
amity10416093__amity
anality10313633anality
aquavit1945203aquavit_
aquavits2043893aquavits
audacity1444823audacity
aurality1139223aurality
brevity1534783brevity
charity15311023charity
clarity12310913clarity
davit93424593_davit_
davits104012363_davits
edacity1336373edacity
equality2046993equality
fugacity1743323fugacity
furmity1535193furmity
heavily1665903heavily
humanity1646313humanity
inanity1039503inanity
laity85318903_la_ity
laxity1637273_laxity
levity1277903_levity
nudity1037993nu_dity
nullity1037363nullity
opacity1436313opacity
orality101111683orality
outcity1238453outcity
outpity1237493outpity
ovality1377593ovality
parity114719873_parity
paucity1435823paucity
privity15268323privity
purity114114913pu_rity
quakily2336693quakily
qualify2235473qualify
quantity2044733quantity
quavery22225483quavery
rarity93615493_rarity
raucity1235853raucity
reality10313573reality
rurality1137403rurality
safety12206913s_afety
sagacity1445243sagacity
saith85826553s_a_ith
salacity1347853salacity
salify12311373s_alify
salty85524383s_a_lty
samite83020603s_amite
satiety1038203s_atiety
satiny93817983s_atiny
saucily1237913saucily
savate9313783s_avate
savin84625083s_avi_n
savine94220283s_avine
saving104724513s_aving
savins93923133s_avins
savior9710173s_avior
savory124310563s_avory
savoy114713883s_av_oy
savvily1634323savvily
savvy14497503s_av_vy
scanty114014663sca_nty
scarcity1545093scarcity
scarify1537443scarify
scarily12311703scarily
scatty115310653sca_tty
scurvily1643783scurvily
sequacity2343823sequacity
sexuality1946073sexuality
shadily1437723shadily
shakily1736903shakily
shanty124715123sha_nty
shavie124312423shavi_e
shavies134213213shavies
shaving143414333shaving
shiviti1344863shiviti
slanty95114843sla_nty
slaty86523153sla__ty
slavery13407893slavery
slavey124011803slav_ey
slaving113514833slaving
slavish1338233slavish
smarty115013793sma_rty
snakily1436913snakily
soapily1237963soapily
sodality12127323sodality
spait75631603spa_it_
spaits85017473spa_its
sparsity1345463sparsity
spavie113611383spavi_e
spavies123012953spavies
spaviet123011933spaviet
spavin114210653spavi_n
spavins12419323spavins
squatty1964823squa_tty
stagily1139053stagily
staving113915703staving
suability1448593suability
suably112814533sua_bly
suasion739363suasion
suasive1037853suasive
suasory1046043suasory
suave83519873suav__e
suaver93014233suav_er
suavest10310623suavest
suavities1248413suavities
subito8410453su_bito
submit10312673submit_
submits1139753submits
subsidy1345973subsidy
subsite9412873subsite
subtilty1345453subtilty
suety85318493su__ety
suit45649873su__it_
suite54829563su__ite
suits55028053su__its
sulfite10310473sulfite
sulkily14218113sulkily
summit10311543summit_
summitry1543323summitry
summits1137983summits
sunlit61516103sunlit_
sunnily1037833sunnily
surety93515013su_rety
surlily10310003surlily
survey124111673surv_ey
survive1335933survive
swarty125812383swa_rty
sylvite13266353sylvite
unity84918493_u_nity
uppity1335103_uppity
vanity12311933_vanity
visuality1545453visuality
wavily15219483_wavily

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.410435831.7
2DLD Change Limit1340271417.31018334.7
3Display Results1411410.0632238.1
 (SQL Overall)1786911417.78322959.1
 
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.