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

81 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
fenceless144416(None) 
benchless1644152benchless
faceless13269172f_aceless
fanciless1444602fanciless
feckless17225782fe_ckless
feeless103511102fe__eless
fenderless1443532fenderless
forceless1435722forceless
menseless1145202menseless
senseless945972senseless
boneless10310213bon_eless
cancelers13247863cancelers
ceaseless1135733ceaseless
centerless1245003centerless
defenseless1551893defenseless
denseness1046863denseness
edgeless1034883_edgeless
endless839833_en_dless
eyeless1058053_e_yeless
fadeless12258323f_adeless
fameless13259203f_ameless
fanciness1437673fanciness
fangless1237663fan_gless
fearless1137873fe_arless
feastless1235043feastless
feelers103814743fe__elers
feetless1137383fe_etless
fenagles12186083fenagle_s
fencerows1742243fencerows
fencers123810623fenc__ers
fences114617113fenc__e_s
fencibles1644093fencible_s
fennels10387903fennel__s
fernless1136063fe_rnless
fierceness1543793fierceness
fineness11310653fin_eness
finless102810783fin__less
fireless112810593f_ireless
flameless1435353flameless
fleckless1842893fleckless
flockless1843163flockless
frameless1435533frameless
frockless1843453frockless
fumeless13236603f_umeless
fuseless11237233f_useless
graceless12226893graceless
iceless9219963__iceless
juiceless1843253juiceless
laceless10239853_laceless
lancelets1144833lancelets
lensless835583len_sless
lineless82711943lin_eless
maneless102812343man_eless
merciless1344473merciless
neckless14236433ne_ckless
nerveless1243933nerveless
offenseless1751353offenseless
paneless102611773pan_eless
pencels113610063pencel__s
pencilers1345643pencilers
penniless1144013penniless
placeless1335613placeless
priceless1336893priceless
punchless1643653punchless
quenchless2441393quenchless
ranchless1444453ranchless
reckless14257973re_ckless
spaceless1335733spaceless
spiceless1335923spiceless
tenseness947113tenseness
tentless8229843ten_tless
tercelets1144813tercelets
toneless8610393ton_eless
traceless11228643traceless
truceless11235393truceless
tuneless837913tun_eless
ventless11249053ven_tless
viceless1337983_viceless
voiceless1444223voiceless
wineless112711173win_eless
zoneless1737823zon_eless

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 Limit148641817.04621095.8
3Display Results81810.0461760.9
 (SQL Overall)178691817.51523777.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.