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

52 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
flatlands136430(None) 
flatland1264961flatland_
flatlander1452452flatlander
flatlanders1551982flatlanders
flatlines12268432flatlines
flatlings13315822flatlings
lallands9338572_lallands
playlands1543892playlands
alands75418373__a_lands
badlands1236673_badlands
blacklands1944123blacklands
coastlands1343313coastlands
fahlbands1842633f_ahlbands
farmlands1543863farmlands
fatlings12359303f_atlings
fenlands1245183f_enlands
filmlands1542903filmlands
flancards1543183flancards
flatbeds14364543flat_beds
flatcaps1563403flatca_ps
flatcars1344623flatca_rs
flatheads1644873flatheads
flatlets1147373flatl_ets
flatline11298923flatlin_e
flatlined13275003flatlined
flatliner12285383flatliner
flatliners13254073flatliners
flatling123410013flatlin_g
flatlong12274523flatlon_g
flatmates1446193flatmates
flattens11357483flatten_s
flatwares1544773flatwares
flatways1744323flatwa_ys
floatplanes1651873floatplanes
forelands1347173forelands
garlands1038323_garlands
hatbands1446293_hatbands
headlands1444903headlands
heartlands1462953heartlands
heathlands1743403heathlands
lalland83810183_lalland_
lallans74113533_lallan_s
lowlands1244373_lowlands
outlands988563_outlands
platanes102711883plat_anes
platans93413123plat_an_s
playland1444573playland_
plowlands1542583plowlands
scablands1443783scablands
shetlands1343743shetlands
wetlands1244763_wetlands
wheatlands1751993wheatlands

Search took 7 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.423422437.4
2DLD Change Limit148641526.42323142.0
3Display Results52520.0301733.3
 (SQL Overall)178691526.87625987.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.