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

110 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
gaseity113511(None) 
gaiety10119372gaie_ty
gasify1336332gas_ify
gaslit7513502gaslit_
gassily1137812gassily
gayety13116382gaye_ty
vastity1336202vastity
acuity1139373_acuity
agility1148653agility
amenity1238333_amenity
amity10416093_a_mity
asperity1347223_asperity
basely114412313base_ly
basest84720493basest_
basicity1546313basicity
basify1437513bas_ify
caseate9314783caseate
casefy1436273case_fy
caseic103212373casei_c
casein83216453casei_n
caseins93115053caseins
casette9310393casette
casita82913703cas_ita
cavity14310013ca_vity
chastity1645273chastity
dacoity1366183dacoity
dakoity1543423dakoity
deity94316773__deity
easily9313023eas_ily
falsity1335903falsity
fatuity1336043fatuity
gadgety13356163gadgety
gaeing84617223ga_eing
gahnite1135973gahnite
gaily95020973ga__ily
gait56150193ga__it_
gaits65726013ga__its
galeate83916793galeate
galenite91210063galenite
galette84212703galette
gambit114714213gambit_
gambits12399723gambits
gamely124711913game_ly
gamest94919933gamest_
gamete9313593game_te
gametic12310003gametic
gamey115320553game__y
gamily123712183ga_mily
gargety12388043gargety
gaseities1047083gaseities
gaselier946963gaselier
gaseous839503gaseous
gases65633993gase__s
gashest114813413gashest_
gashing125119233gashing
gasket114417253gasket_
gaskets12348153gaskets
gaskin113610583gaski_n
gasking134415913gasking
gaskins123510773gaskins
gasping113714363gasping
gassier83812573gassier
gassing94216333gassing
gassy95514023gas__sy
gast56052563gas__t_
gasting95022763gasting
gasts66628633gas__ts
gateway1434933gateway
gaudily1236523gaudily
gauzily2034393gauzily
gawkily1834093gawkily
gayest104314333gayest_
gazette17357363gazette
glassily1235463glassily
gleety10479193g_leety
gossipy1343953gossipy
grassily1236433grassily
gratuity1244283gratuity
gravity1437183gravity
gushily14257823gushily
gustily113010903gustily
gusty95119573gus__ty
hastily133010663hastily
hasty115718763has__ty
jadeite1546403jadeite
laity85318903la__ity
laxity1637273la_xity
majesty1943503majesty
nasality1146653nasality
nastily103011033nastily
nasty85717283nas__ty
obesity1275653obesity
parity114719873pa_rity
pasty105725053pas__ty
paucity1435823paucity
rabbity14266303rabbity
rarity93615493ra_rity
raucity1235853raucity
safety12206913safe_ty
sanity9316203sa_nity
sassily1038723sassily
satiety1038203satiety
tastily103311643tastily
tasty84820313tas__ty
vacuity1545763vacuity
vanity12311933va_nity
variety1337743variety
varsity1356673varsity
vasty116215923vas__ty
waspily1535513waspily

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.403443402.0
2DLD Change Limit1340271106.65620136.3
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.10525150.0
 
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.