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

62 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
ladykin154396(None) 
ladykins1643601ladykins
lambkin1545242lambkin
layin84720332la_y_in
adjoin14107293_adjoin
akin86328033_a__kin
aldrin7311243ald_rin
ayin76331743_a_y_in
baudekin1542703baudekin
bodkin1338923bod_kin
calkin123515493ca_lkin
canakin131810833canakin
canikin13189753canikin
catkin123512383ca_tkin
dyking15458013__dyking
fadein1068843fad_ein
gaskin113610583ga_skin
kidskin1143833kidskin
lacking143821543la_cking
laddie83713173lad_die
laden65022193lad__en
ladening1078823ladening
lading84227123lad__ing
ladino73615123lad__ino
ladling92813393lad_ling
ladron73413323lad_ron
lady86527153lady___
ladybird1542153ladybird
ladybug1441473ladybug
ladyfish1843803ladyfish
ladyish14287823ladyish
ladylike1634683ladylike
ladyship1743553ladyship
lain46146283la___in
laking115027043la__king
lambkins1664983lambkins
lambskin1653443lambskin
laminin939973laminin
landskip1583673landskip
lanolin7310643lanolin
lapin75222923la__pin
larking123718253la_rking
larrikin1243793larrikin
latakia1146093latakia
lattin64316223la_ttin
laying104525703la_y_ing
layins93817653la_y_ins
layman113511303la_yman
laymen113010843la_ymen
lazying2046673lazy_ing
limpkin1534223limpkin
lysin84512783l__ysin
malkin122913153ma_lkin
manakin131810643manakin
manikin132110243manikin
mayvin1436523ma_yvin
nankin1039673na_nkin
napkin1236903na_pkin
ramekin13126493ramekin
redskin1286023redskin
takin94921303ta__kin
zayin174512043za_y_in

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.393454684.5
2DLD Change Limit134027625.96622465.1
3Display Results62620.0163875.0
 (SQL Overall)178691626.37528030.0
 
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.