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

97 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
unfencing154595(None) 
defencing16226692defencing
fencing132411132__fencing
outfencing1645292outfencing
refencing15188852refencing
unbending1337462unbending
unending10239942un_ending
unfearing1338882unfearing
unfeeling1337112unfeeling
unpenning1236182unpenning
cadencing1544963cadencing
defending15298353defending
defensing14217003defensing
enfacing1467293enf_acing
enforcing1545473enforcing
enhancing1545823enhancing
enouncing1245583enouncing
fencings14225663__fencings
fending123717603__fending
incensing1297663incensing
incenting12912063incenting
indenting11911263indenting
infecting15109673infecting
inferring1338613inferring
infesting13109513infesting
influencing1751863influencing
intending1139983intending
inventing13109973inventing
licencing1443853licencing
offending1744093offending
sentencing1345403sentencing
silencing1245053silencing
unbanning1235893unbanning
unbearing1239353unbearing
unbeing1039373unbe__ing
unbelting1237663unbelting
unbendings1443163unbendings
unbenign1142533unben_ign
unbinding1336513unbinding
unbracing1437023unbracing
unceasing1239653unceasing
unclenching1952133unclenching
underling111514613underling
underwing141410883underwing
unerring9311273un_erring
unfading1347693unf_ading
unfailing1337453unfailing
unfence1239193unfenc__e
unfenced1437733unfenc_ed
unfences1337933unfenc_es
unfitting1336423unfitting
unfixing1935683unf_ixing
unflinching2051693unflinching
unfolding1436063unfolding
unfreeing1345103unfreeing
unfreezing2343343unfreezing
unfrocking2043533unfrocking
unfurling1335763unfurling
ungenuine1043803ungenuine
unhanding1437203unhanding
unhanging1436363unhanging
unheeding1446103unheeding
unhelming1535493unhelming
unhinging1436093unhinging
unkinking1334783unkinking
unlacing1148653un_lacing
unleading1138673unleading
unlinking1436273unlinking
unmanning1245873unmanning
unmeaning1237953unmeaning
unmeshing1595933unmeshing
unmewing1485913unme_wing
unnerving1336633unnerving
unpegging1443863unpegging
unpinning1245623unpinning
unreeling1038983unreeling
unreeving1336213unreeving
unresting10311133unresting
unsealing10711043unsealing
unseaming1278113unseaming
unseating10713203unseating
unseeing988293unse_eing
unselling10810333unselling
unsetting1088993unsetting
unsewing1287433unse_wing
unsexing1686853unse_xing
unteaching1645493unteaching
untuning937943untun_ing
unveiling1337723unveiling
unvoicing1545083unvoicing
unwaning1238133unwan_ing
unweaving1636133unweaving
unweeting1336473unweeting
unwinding1435843unwinding
unwinking1735073unwinking
upending12258133u_pending
upsending1334903upsending

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 Filter1786911486410.470380193.6
2DLD Change Limit148641976.32623496.8
3Display Results97970.0631539.7
 (SQL Overall)178691976.85926052.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.