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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
annulation106895(None) 
angulation1149551angulation
annulations1167831annulations
adulation10311012a_dulation
ambulation1447872ambulation
angulations1268052angulations
annexation1744952annexation
annotation1047752annotation
insulation10311662insulation
undulation1147102undulation
abjuration1945883abjuration
ablation10312433a__blation
abnegation1345413abnegation
accusation1466903accusation
acidulation14105403acidulation
actuation11310333actu_ation
acylation1448653a_cylation
adjuration1845523adjuration
adnation9310783adn__ation
adulations11310123a_dulations
agnation9311723agn__ation
alation72920553a___lation
alkylation1743823alkylation
ambulations1547113ambulations
amputation1447343amputation
angulating1247823angulating
animation11313683a_nimation
annexations1844263annexations
annihilation1594503annihilation
annotations1146883annotations
annulate8310923annulat__e
annulated1038603annulat_ed
annunciation1462893annunciation
arcuation11410583arcu_ation
calculation1548293calculation
cancelation1547783cancelation
cannulating1446013cannulating
conflation15412083conflation
copulation141111953copulation
crenulation1347573crenulation
cumulation1448173cumulation
denudation1247303denudation
emulation11312393_emulation
granulation1246553granulation
incubation1448363incubation
inculcation1557243inculcation
inculpation1546773inculpation
induration11410613induration
inflation12311093_inflation
inhalation13107663inhalation
inhumation1567053inhumation
innovation1345643innovation
inoculation1358713inoculation
insolation10410213insolation
insulations11310233insulations
intubation1247773intubation
inundation11116173inundation
lobulation1247233lobulation
maculation14510983maculation
manipulation1654663manipulation
modulation13147933modulation
morulation12148903morulation
nodulation11127993nodulation
nunnation9126563_nunnation
nutation81513103__nutation
osculation1249673osculation
ovulation1238983_ovulation
peculation14311993peculation
population14810023population
regulation11312053regulation
sacculation1547843sacculation
simulation1269583simulation
sinuation9310413sinu_ation
tabulation1247813tabulation
ululation938093_ululation
undulations1246053undulations

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 Filter1786911406030.436409841.7
2DLD Change Limit140603767.31319226.4
3Display Results76760.0461652.2
 (SQL Overall)178691767.79522923.8
 
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.