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 “flatlanders” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
flatlanders155198(None) 
flatlander1452451flatlander_
flatlands1364302flatland__s
flatliners13254072flatlin_ers
flatland1264963flatland___
flatliner12285383flatlin_er_
flatlines12268433flatlin_e_s
flatteners13164153flatten_ers
lowlanders1442693_lowlanders
malanders1237023_ma_landers
outlanders1144273_outlanders
uitlanders1142833_uitlanders
alexanders1842444al_exanders
atlantes838554__atlante_s
attainders11112774__attainders
attenders1045274__attenders
auslanders1143364_auslanders
balancers1345064_ba_lancers
bilanders1235964__bilanders
blackhanders2462404blackhanders
bystanders1642194byst_anders
calamanders1662914calamanders
calenders1237404_ca_lenders
colanders1238014__colanders
fatalness1245774f_ataln_ess
fatteners12236874f_atten_ers
flagrances1644184flagrance_s
flangers123311374f___langers
flankers15349304f___lankers
flatcars1344624flatca___rs
flatlets1147374flatl___ets
flatline11298924flatlin_e__
flatlined13275004flatlin_e_d
flatlings13315824flatlin__gs
flatmates1446194flatma_te_s
flatness1138154flat__n_ess
flattener12175174flatten_er_
flatterers13175914flat_terers
flatters113814204flat___ters
flatulences1692314flatulence_s
flatwares1544774flatwa_re_s
flatwashes1941954flatwashe_s
flaunters1234514fla__unters
flinders12439264f___linders
floatplanes1651874floatplan_e_s
flounders1374614fl__ounders
freelancers1652354freelancers
glanders103811504___glanders
goaltenders1351804goaltenders
highlanders1952024highlanders
inlanders1036144__inlanders
islanders1035284__islanders
lallands9338574_lalland__s
landers84026214____landers
lateeners945564_lateen_ers
launders9358744_la__unders
lavenders1334754_la_venders
lowlander1342994_lowlander_
mainlanders1462504mainlanders
oleanders1035574ol__eanders
outlander1045734_outlander_
phalangers1673764pha_langers
philanders1644274_philanders
platanes102711884plat_an_e_s
playlands1543894playland__s
salamanders1462204salamanders
slanders94014014___slanders
solanders1036964__solanders
standers93514304__st_anders
stranders10389934__stranders
tailenders1143644_tailenders
uitlander1042964_uitlander_
uplanders1234854__uplanders
woodlanders1652164woodlanders

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 Filter1786911488190.423422437.4
2DLD Change Limit148819748.26618003.8
3Display Results74740.0461608.7
 (SQL Overall)178691748.73520456.9
 
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.