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

89 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
annulled94484(None) 
annealed936342annealed
annulated1038602annulated
annulet7311592annu_let
anvilled1236482anvilled
nulled74318272__nulled
undulled1036992undulled
aneled74719283a_n_eled
angeled93211513a_ngeled
angled84219093a_n_gled
angulated1139223angulated
ankled114313483a_n_kled
annealer845503annealer
annelid838733ann_elid
annexed1535753ann_exed
announced1243293announced
annoyed1185873ann_oyed
annual64710703annual__
annualized2044613annualized
annually1145833annually
annuals7388193annual_s
annul55813383annu_l__
annular737703annu_lar
annulate8310923annulate
annulets845813annulets
annuli6459053annu_l_i
annulling1045003annulling
annulment1145683annulment
annulose844473annulose
annuls64711733annu_l_s
annulus7426613annu_lus
annuluses943913annuluses
anviled1138953a_nviled
appalled1344813appalled
avulsed1133833a_vulsed
awfuller1442423awfuller
bulled94626493__bulled
canalled1139583canalled
cancelled1456743cancelled
cannulae1046503cannulae_
cannulated1346503cannulated
channelled1644143channelled
culled94022473__culled
disannulled1351723disannulled
dulled84719423__dulled
engulfed1342783engulfed
ennobled1143833ennobled
enrolled967973enrolled
flannelled1442843flannelled
fulled103820653__fulled
funnelled1374233funnelled
gulled84521373__gulled
hanselled1345483hanselled
hulled103920013__hulled
indulged1144073indulged
ingulfed1343173ingulfed
insulted937193insulted
inwalled1275773inwalled
kennelled1443513kennelled
knelled12338993_knelled
knolled12296573_knolled
knurled1244653_knurled
lulled74516443__lulled
mulled94721553__mulled
nilled73919453__nilled
nurled74016233__nurled
panelled1138973panelled
pulled94322193__pulled
sandalled1145903sandalled
sculled102911693_sculled
skulled12317403_skulled
snelled83313053_snelled
tunnelled1054583tunnelled
unbilled1188693unbilled
uncalled11810923uncalled
uncurled1168963uncurled
unfilled1298383unfilled
unfurled1277203unfurled
ungalled1078463ungalled
unmilled1197853unmilled
unnailed9229443unnailed
unpolled1168943unpolled
unquelled1944413unquelled
unrolled9610413unrolled
unruled8311373unru_led
unsullied1044543unsullied
untilled9710563untilled
unwalled1288653unwalled
unwilled1277823unwilled

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 Filter1786911461620.420425454.8
2DLD Change Limit146162897.01620832.7
3Display Results89890.0461934.8
 (SQL Overall)178691897.48223882.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.