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

94 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
lowlands124437(None) 
lowland1134691lowland_
plowlands1542581plowlands
cowhands1765262cowhands
downlands1453852downlands
hollands12247272hollands
lallands9338562lallands
lowlander1342992lowlander
lowlanders1442692lowlanders
norlands936442norlands
plowland1442742plowland_
snowlands1343562snowlands
solands84412342so_lands
alands75418373__alands
badlands1236673badlands
blowhards1843273blowhards
bollards11339153bollards
bowlines133211623bowlines
bowlings14408753bowlings
browbands1743393browbands
cloudlands1471713cloudlands
collards113310193collards
commands15318813commands
coolants1039943coolants
cowards1339613cow_ards
cowbanes1537423cowbanes
cowbinds1634453cowbinds
cowhand1665933cowhand_
cowlings14359773cowlings
croplands1445373croplands
docklands1743153docklands
downland1364533downland_
elands74914773__elands
fenlands1245183fenlands
flatlands1364303flatlands
forelands1347173forelands
foulards12266463foulards
fowlings15377243fowlings
garlands1038323garlands
glands85314403__glands
gormands1266563gormands
gowans105512293gow_an_s
holards1148433ho_lards
holland11349473holland_
homelands1545433homelands
inlands838783_inlands
islands837323_islands
lalland83810173lalland_
lallans74113533lallan_s
lands65426903___lands
ligands9438983l_igands
llanos6108333l__lanos
loads65323373lo__a_ds
loans56026463lo__an_s
lochans1248833lochan_s
logans76319063lo_gan_s
longans84510813longan_s
longhands1443613longhands
lorans65117603lo_ran_s
lotuslands1151773lotuslands
lowballs1364393lowballs
lowings113710073low_ings
lowlifes1434333lowlifes
lowliness1236403lowliness
lowlives1434573lowlives
midlands1245543midlands
moorlands1244203moorlands
norland837163norland_
outlands988563outlands
playlands1543893playlands
poblanos1244993poblanos
pollards11299523pollards
poulards11288233poulards
relands85214883_relands
rimlands1145243rimlands
robands10219853ro_bands
rowans95715343row_an_s
snowland1243833snowland_
soland75115043so_land_
solanos74412853so_lanos
solans64122493so_lan_s
sowans94215893sow_an_s
sunlands936383sunlands
tolanes74216303to_lanes
tolans64319273to_lan_s
towards1138783tow_ards
towlines112610343towlines
towmonds1493493towmonds
towplanes1444683towplanes
trolands936413trolands
uplands1036943_uplands
wands96425483__w_ands
wetlands1244763wetlands
woodlands1444153woodlands

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.1731032896.0
2DLD Change Limit146162947.37319824.0
3Display Results94940.0332848.5
 (SQL Overall)178691947.57923577.1
 
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.