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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

129 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
subirrigation165264(None) 
subirrigations17102401subirrigations
subirrigating1761742subirrigating
irrigation1147803___irrigation
suberization2359233sub_erization
subirrigate1452223subirrigat__e
subirrigated1651803subirrigat_ed
subirrigates1551993subirrigat_es
subordination1654163subordination
subrogation1446003sub__rogation
irrigations1246944___irrigations
irritation1048974___irritation
lubrication1546344lub__rication
rubrication1547124rub__rication
suberizations2468764sub_erizations
subjugation2143704sub__jugation
sublimation1557184sub__limation
subordinations1753994subordinations
subornation1346484sub_or_nation
subrogations1545454sub__rogations
subscription1853124subscri_ption
subsidization2553984subsidization
subtilization2456624subtilization
summarization2655284summarization
supererogation1763064supererogation
susurration1144794susurr__ation
aberration1267205_aberr__ation
abrogation13107335_ab__rogation
arbitration1346475arbitr__ation
arborization2347885arb_orization
arrogation11107445___arrogation
authorization2555855authorization
corrugation1445995__corrugation
curarization2348195cu_rarization
debilitation1547785debi_litation
defibrination1953865defibrination
dubitation1377335dub___itation
fabrication1846605fab__rication
fiberization26136715fib_erization
fumigation1645625fu___migation
fustigation1545215fu__stigation
habilitation1795515habi_litation
hebraization26126145heb_raization
humification2246105humi_fication
humiliation1675195humi_li_ation
hybridization3152565hybridization
imbrication1746465imb__rication
insubordination1861795insubordination
interrogation1457865interrogation
irrigating1245945___irrigating
irrigator1045705___irrigat_or
irritations1147835___irritations
jubilation1946055jub___ilation
labialization2458345labialization
litigation1148175__li_tigation
lubrications1645735lub__rications
mitigation1348645__mi_tigation
mobilization2588675mobi_lization
objurgation2152405_objur_gation
obligation1346785_ob__ligation
publication1746575pub__lication
pulverization2754715pulverization
purgation1247395pu___r_gation
purification1948175puri_fication
rubrications1646265rub__rications
salinization2158895sali_nization
sanitization2149145sani_tization
scarification2056405scarification
segregation1346385s__egregation
serialization22911715serialization
seriation9318065s___eri_ation
serration9414055s__err__ation
sibilation12128775s__i_bilation
socialization2449095socialization
solarization211810165s_olarization
solicitation1445365soli_citation
solubilization2554045solubi_lization
sovietization2554785sovietization
stabilization2466185stabi_lization
sterilization2258845sterilization
striation9313485s___tri_ation
suballocation1761625suballocation
subaudition1452685subaudi__tion
subgeneration1652605subgeneration
subinfeudation20121465subinfeudation
subjugations2253415sub__jugations
sublation11311015sub____lation
sublimations1646085sub__limations
subluxation2043825sub__luxation
submunition1563105submuni__tion
subordinating1753085subordinating
subordinative1962415subordinative
subordinator1562425subordinat_or
suborganization2762175suborganization
subornations1446135sub_or_nations
subpopulation1962655subpopulation
subregion1244295sub__reg__ion
subreption1445825sub__r_eption
subrogating15164985sub__rogating
subsaturation1553075subsaturation
subscriptions1952825subscri_ptions
subsidizations2653735subsidizations
substation1248985sub___station
substitution1453315sub_stitution
subtilizations2556055subtilizations
subtraction1545625sub_tr_action
suburbanization2862045suburbanization
suffixation2452865su__ffixation
summarizations2754835summarizations
supererogations1862825supererogations
superfetation1855225superfetation
supernation13411665su_per_nation
superstation14168625su_perstation
supination1249885su___pination
supplication1855395su_pplication
suppuration1545895suppur__ation
surrogating13194315su__rrogating
suspiration1346545su__spiration
susurrations1244335susurr__ations
umbilication1884745umbi_lication
unification1648735_uni_fication
unionisation1253445_unionisation
unionization2156035_unionization
unirrigated1353285_unirrigat_ed
unitization2048135_uni_tization
urination9312175_u___rination
urtication1249115_u__rtication
utilization2049685_uti_lization
vulgarization2654825vulgarization

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901297.67316263.5
3Display Results1291290.0761697.4
 (SQL Overall)1786911297.88922650.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.