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

132 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
giantess93389(None) 
gainless9117412gainless
giantesses1143512giantesses
giantism1155382giantism
giantisms1244812giantisms
giants74713502giant__s
grantees92510972grantees
granters93614152granters
antes56334323__ante_s
banters94623123_banters
biasness1035813biasness
bigness1038193bign_ess
canters94827733_canters
chanters134016743chanters
chanteys16387493chanteys
countess103710053countess
dianthus1243393dianthus
diastems11226523diastems
diasters92913183diasters
dimness1038843dimn_ess
fainters11349693fainters
faintest1139073faintest
faintness1235833faintness
fatness103311293_fatness
fiancees1335103fiancees
fiances12310673fiance_s
finless102810783fi_nless
fitness10299393fitn_ess
flatness1138153flatness
gainers84214593gain_ers
gaiters83516543g_aiters
ganders93521703g_anders
ganefs10489203g_an_efs
ganevs10456913g_an_evs
gangers94418603g_angers
gannets83811443g_annets
gantlets9308903g_antlets
gapless10349993g_apless
garters84218253g_arters
gasless8319013g_asless
gasters85624303g_asters
gastness9278483g_astness
gaters74728643g_a_ters
gates65939513g_a_te_s
gauntest936603gauntest
gauntness1044203gauntness
gayness1136843g_ayness
gearless937373gearless
gentes75324163g_ente_s
giant65430593giant___
giftees11306513gi_ftees
giftless1245173giftless
gigantean1151263gigantean
gigantism1343373gigantism
gigantisms1453123gigantisms
gingers94118643gi_ngers
ginners84314223gi_nners
ginniest92610513ginniest
gites65630183gi__te_s
gladness1036153gladness
glancers11408003glancers
glances104113143glance_s
glanders103811513glanders
glandes95413833glande_s
glandless1134163glandless
glibness1134143glibn_ess
goalless935723goalless
goatees82710443goa_tees
grafters12409193grafters
grainless1035903grainless
grandees103211283grandees
grandest10311573grandest
grandness1138303grandness
grangers103011973grangers
granges93516523grange_s
granites92116363granite_s
granted94715103grante_d
grantee83217133grante_e
granter84117133grante_r
grantors93810363grantors
grants73722473grant__s
graters85419743gra_ters
grates75429893gra_te_s
grayness1235933grayness
greatness1036903greatness
grimness1176003grimn_ess
grunters9359043grunters
guanases936233guanases
gunless8299633g_unless
hinters103719583hi_nters
hipness12277383hipn_ess
innless7288293_innless
inters64328053_i_nters
kinless113310273ki_nless
leanness837373leanness
lianes63819323lian_e_s
lintels73311163li_ntels
linters73822633li_nters
lintless82710013li_ntless
lioness739103lion_ess
manless93012933_manless
mantels94515043_mantels
mantes84430783_mante_s
meanness1037183meanness
minters93822473mi_nters
neatness839153neatness
painless10108363painless
painters103013033painters
patness92912283_patness
piasters102912813piasters
planless1036833planless
planters102915333planters
pliantness1263653pliantness
rainless8129713rainless
ranters73323643_ranters
scantest101710183scantest
scantness1135733scantness
shanteys14395513shanteys
sinless73014213si_nless
sinters74024083si_nters
spanless10247363spanless
taintless935743taintless
tinters74221113ti_nters
tintless8239863ti_ntless
titaness836723titan_ess
vainness1136063vainness
wanness102610683_wanness
wanters104420093_wanters
whatness1435093whatness
winless103212283wi_nless
winters103720483wi_nters
witness103010013witn_ess

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621327.57619292.8
3Display Results1321320.0632095.2
 (SQL Overall)1786911328.04522211.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.