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

69 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
yachtings184266(None) 
yachting1734931yachting_
actings104512462_ac_tings
acetins9313173_acetin_s
aching126521973_ach_ing_
acting95920983_ac_ting_
actins86321103_ac_tin_s
antings85015583_a_ntings
archings14499863arch_ings
baching156017753bach_ing_
backings174012213bac_kings
bashings144311243bash_ings
bastings114214693ba_stings
battings114010573ba_ttings
cacheting1737153cacheting_
caching156317503cach_ing_
castings113614053ca_stings
ductings12346673duc_tings
eastings93412953ea_stings
eatings84616443ea__tings
etchings14396293etch_ings
faceting1438783faceting_
facings134511263fac__ings
fagotings1443153fagotings
farthings1635233farthings
fastings124011943fa_stings
fightings17276503fightings
gatings95212823ga__tings
hatchings18225673hatch_ings
hatchlings1943033hatchlings
itchings14386193itch_ings
kachinas1736343kach_inas
kartings13418523ka_rtings
lacewings1543303lacewings
lacings105013653lac__ings
lashings124412253lash_ings
lastings94214423la_stings
lathings12469853lath_ings
lichting14268513lichting_
lightings14277723lightings
lynchings18233503lynch_ings
machines15312893mach_ines
matings104516213ma__tings
mattings11369673ma_ttings
naethings1343873naethings
packings174310063pac_kings
paintings12327093paintings
partings113513733pa_rtings
racheting1537793racheting_
racings105015133rac__ings
ratings84217413ra__tings
ruchings14287073ruch_ings
sackings15389633sac_kings
sacrings11278923sac_rings
saltings92811253sa_ltings
sightings14256533sightings
tacklings16235853tacklings
tattings9408823ta_ttings
teachings15296553teach_ings
vacating14310353vacating_
vaultings13233633vaultings
waistings1352710763waistings
waitings123413743wa_itings
washings15419273wash_ings
wauchting1843473wauchting_
yachters1633883yacht_ers
yachts1437023yacht___s
yacking174315683yac_king_
yawpings17253583ya_wpings

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit148641696.58022589.8
3Display Results69690.0302300.0
 (SQL Overall)178691697.03325407.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.