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

44 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
motherlands175235(None) 
motherland1652611motherland_
fatherlands1852502fatherlands
borderlands1551843borderlands
fatherland1753003fatherland_
moorlands1244203mo__orlands
motherboards2052313motherboards
motherhoods2092803motherhoods
motherings16255643mother_ings
motherless1544093motherl_ess
motherliness1753083motherliness
overlands13218883_o_verlands
wonderlands1652203wonderlands
borderland1452164borderland_
bottomlands1651054bottomlands
eutherians1345314eutherian_s
forelands1347174fo_re_lands
hinterlands1553004hinterlands
homelands1545444ho_me_lands
hotheads15318014hothe__a_ds
interlards1146814int_erlards
interlends1148604int_erlends
lotuslands1151774lot_uslands
metheglins1653104metheglin_s
monerans10310344mo_ner_an_s
moorland1144684mo__orland_
motherboard1952724motherboard_
mothered142310104mother__ed_
motherhood1993044motherhood_
mothering152110184mother_in_g
motherly16346094motherl___y
mothers123717624mother____s
norlands936444no___rlands
northlands1443184north__lands
operands1146814_o_per_ands
overhands16227804_o_verhands
overland122312004_o_verland_
overlends13237524_o_verlends
potheads14298544pothe__a_ds
shetlands1343744__shetlands
southlands1463354south__lands
therians1138314__therian_s
timberlands1651794timberlands
wonderland1552594wonderland_

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.186960704.3
2DLD Change Limit148819448.50017508.1
3Display Results44440.0162750.0
 (SQL Overall)178691448.70220534.5
 
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.