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

73 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
yardarm1311453(None) 
yardarms14123331yardarms
sardar73013172sardar_
sardars83112902sardars
yardage1235732yardage
yarder103813972yarder_
yarders113211592yarders
aardvark162315973aardvark
alarm76621423_a_larm
ardor64617863_ardor_
ardors74416873_ardors
ariary94114203_ariary
aswarm11107913_aswarm
barware12610703barware
birdfarm1642873birdfarm
carbarn1139453carbarn
cardamom1543883cardamom
cardamum1543103cardamum
carder94524183carder_
carders104820353carders
carfare12310073carfare
darbar959953darbar_
darbars10510093darbars
eardrum10135423eardrum
earmark1345653earmark
earworm1238743earworm
firearm1237203firearm
forearm1238703forearm
garda7316763garda__
gardai839663garda_i
gardant9314463gardant
gaydar1135503gaydar_
gaydars1235803gaydars
hadarim13117453ha_darim
hardass1139753hardass
harder105022403harder_
hardware1546283hardware
larder73720973larder_
larders83516943larders
madam10316223ma_da_m
marram10313883marra_m
pardah123412823parda_h
pardahs13289673pardahs
prearm104512353_prearm
radar61316723ra_dar_
radars71314673ra_dars
rearm75923573__rearm
sarcasm1136693sarcasm
sardana838643sardana
sarsar63011843sarsar_
sarsars73512143sarsars
sirdar7269103sirdar_
sirdars8228213sirdars
tartar63214753tartar_
tartare73012683tartare
tartars73313403tartars
warder104020273warder_
warders113416813warders
warfare1336733warfare
yard85633253yard___
yardages1336203yardages
yardbird1542323yardbird
yarded114714023yard_ed
yarding123413143yarding
yardland1343763yardland
yardman1335913yardman
yardmen1335423yardmen
yards95324613yard__s
yardwand1642743yardwand
yardwork1944513yardwork
yarer84321573yar_er_
yarner93313063yarner_
yarners104312203yarners

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 Filter1786911340270.390458182.1
2DLD Change Limit134027736.41020909.0
3Display Results73730.0302433.3
 (SQL Overall)178691736.83026162.7
 
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.