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

50 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
yardland134376(None) 
yardlands1443581yardlands
yardwand1642741yardwand
badland1147652ba_dland
farmland1454232farmland
garland948702gar_land
parkland1545362parkland
yardman1335912yardman_
yardwands1742682yardwands
aland65526413_a__land
armband1265983_armband
backland1748103backland
badlands1236673ba_dlands
barehand1446153barehand
dryland1254303_dryland
fairyland1642423fairyland
farmhand1743563farmhand
farmlands1543863farmlands
foreland1239013foreland
gangland1145193gangland
gardant9314463gard_ant
garlands1038323gar_lands
graduand1143893graduand
hardline12310273hardline
hardpan1336443hardpan_
hardpans1436453hardpans
hardstand1444473hardstand
headland1345613headland
heartland1343653heartland
lalland83810173la_lland
mainland1145213mainland
marchland1743833marchland
marshland1543353marshland
midland1136603_midland
norland837163nor_land
parklands1654713parklands
parlando1145413par_lando
reland75920433__reland
saraband1146193saraband
sardana838643sard_ana
troland837543_troland
warplane1345983warplane
wildland1353843wildland
woodland1344603woodland
yardage1235733yard_age
yardarm13114533yard_arm
yardbird1542323yardbird
yarded114714023yard__ed
yarding123413143yard_ing
yardmen1335423yardmen_

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162507.83018666.9
3Display Results50500.0301666.7
 (SQL Overall)178691508.01622291.8
 
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.