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 “fenced” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
fenced12441271(None) 
fence105319911fence_
fencer114613531fencer
fences114617111fences
fended114216911fended
benched154713942benched
bended105521232bended
censed94016322censed
danced105315252danced
defenced1537202defenced
deiced104214482deiced
denied84318632denied
denned84215632denned
dented84120512dented
deuced104112122deuced
ended74421262_ended
faced117727652f_aced
fancied133310602fancied
fanged114318222fanged
fanned104117472fanned
farced125216532farced
feared106320432feared
feased105718712feased
feazed195112632feazed
feces105625362fe_ces
feed84538902fe__ed
feezed19439992feezed
feinted11379622feinted
felled103720302felled
felted103714652felted
fencers123810622fencers
fend84832972fen__d
fender103718722fender
fennec11326912fennec
fennel9429472fennel
fessed104515062fessed
fetched163710472fetched
feted94420932fe_ted
fetted104817892fetted
feuded114010002feuded
feued94715662fe_ued
fezzed18398242fezzed
fined94930502fin_ed
finked144214622finked
finned104114602finned
fleeced13358152fleeced
flenched17267962flenched
flensed1136612flensed
fonded115717042fonded
forced126316522forced
frenched17299432frenched
funded114413892funded
funked144214112funked
funned103613952funned
hence104920042hence_
hented104218752hented
kenned114411272kenned
lanced93717722lanced
lensed74015472lensed
menaced122710092menaced
mended104418682mended
mensed93916542mensed
minced114114912minced
peaced115818912peaced
pence94924452pence_
pencel103812912pencel
pended103819012pended
penned94217612penned
ponced114314812ponced
refenced1438992refenced
rended84524102rended
rented74426592rented
sended85121232sended
sensed73918162sensed
synced12266962synced
tended83819482tended
tensed74817832tensed
tented74221002tented
unfenced1437732unfenced
vended114416352vended
venged114011992venged
vented104617922vented
wenched163910912wenched
wended113616152wended
winced124415342winced
yenned10409382yenned
zinced18419412zinced

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551872.45333653.1
3Display Results87870.0332636.4
 (SQL Overall)178691872.82963164.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.