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

88 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
abseiled114473(None) 
abscised1364132abscised
abseil837182abseil__
abseils935972abseil_s
absented1156612absented
assailed945322assailed
assoiled935022assoiled
abaxile1644083abaxile_
abele76323253ab_e_le_
abeles84719393ab_e_les
abetted1058323ab_etted
abided105313313ab__ided
abled86926833ab___led
abscessed1442703abscessed
abscise1145953abscise_
abscises1246233abscises
abseiling1265343abseiling
absence1137703absence_
absences1247673absences
absentee1067663absentee
absenter1086773absenter
absolved1443133absolved
absorbed1344263absorbed
abstained1245053abstained
absterged1353353absterged
ailed66240283a___iled
aisled74516183ais__led
aneled74719283a_ne_led
angeled93211513ange_led
annealed936343annealed
anviled1138953a_nviled
appealed1335603appealed
ariled75620323a__riled
aspired1068173a_spired
assailer844823assailer
assembled1443693assembled
assented957513assented
asserted957903asserted
assessed945023assessed
aureoled945743aureoled
availed1135973a_vailed
axseed1456993axse__ed
bailed94726653_b_ailed
basined10310003bas_ined
bastile9313913bastile_
bastiles10313353bastiles
beetled1038213_beetled
belied95022163_b_elied
belled94626183_b_elled
besmiled1335493besmiled
boiled95020953_b_oiled
brailed103914013_brailed
broiled103811423_broiled
ceiled94114953__ceiled
easeled8159853ease_led
ensiled82611433ens_iled
gabelled12317583gab_elled
hanseled1237713hanse_led
hanselled1345473hanselled
heiled104415613__heiled
labeled102510563lab_e_led
labelled11278293lab_elled
misfiled14278653misfiled
observed1444373observed
obsessed1144273obsessed
resailed93613063resailed
resealed92713963resealed
reseized1839213reseized
resiled84621983res_iled
sailed74327763__sailed
sealed74328363__sealed
seeled73922093__seeled
seined74023063__seined
seised74218123__seised
seized164313653__seized
smiled93716433__smiled
soiled73822473__soiled
speiled104412123_speiled
spiled94621993__spiled
subsoiled1245453subsoiled
tasseled935593tasse_led
tasselled1044633tasselled
unsealed91513623unsealed
unseized1838443unseized
unsoiled92412083unsoiled
unveiled1298163unveiled
veiled103714543__veiled
wassailed1343153wassailed

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.420425454.8
2DLD Change Limit146162887.59619242.0
3Display Results88880.0461913.0
 (SQL Overall)178691888.06222164.6
 
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.