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

70 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
laterally124807(None) 
literally1248341literally
alterably1447202alterably
bilaterally1653072bilaterally
enterally12410012enterally
lacteally1444472lacte_ally
lateral7313572latera_l_
lateraled1047462lateraled
lateralled1144782lateralled
laterals8312752latera_ls
liberally1446262liberally
materially1548002materially
maternally1545762maternally
naturally1246522naturally
paternally1545862paternally
aborally1347063_aborally
aerially11911913_a_erially
alterable1149163alterable
amorally1348093_amorally
areally10411243_are_ally
arterially1347333arterially
astrally1148883_astrally
atonally1148633_atonally
aurally10310543_a_urally
bacterially18114963bacterially
caecally1547703ca_ecally
collaterally1752823collaterally
eternally1247493_eternally
externally2045543externally
fatally1339893fat__ally
fatefully1844753fatefully
federally1645293federally
fraternally1753493fraternally
generally1347343generally
hatefully1844773hatefully
integrally1445893integrally
internally13410093internally
labially1336983la_bially
lacerable1346943lacerable
laically1338983la_ically
lately93413843late___ly
latently1146353late_ntly
laterad8310843latera__d
lateraling11148803lateraling
lateralize1949053lateralize
lateralling1244633lateralling
latterly1136063latter__ly
leally94012613l__e_ally
legally1138133l__egally
lethally1445923let_hally
lineally1137793line_ally
literacy1346803litera_cy
literal7613273litera_l_
literality1346903literality
literals8312293litera_ls
literarily1354273literarily
literary1147753litera_ry
literately1345303literately
lytically1757383lytically
numerally1446133numerally
pastorally1565443pastorally
rateably1337783rate_ably
retrally11310523ret_rally
severally1546243severally
suturally1245953suturally
unilaterally1553053unilaterally
waterfall1544583waterfall_
waterfalls1644763waterfalls
waterily1438783water_ily
waterlily1544343waterlily

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 Filter1786911486410.453394461.4
2DLD Change Limit148641706.54622707.1
3Display Results70700.0302333.3
 (SQL Overall)178691707.02925422.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.