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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

179 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
unfearing133888(None) 
unbearing1239351unbearing
anearing9413972an_earing
endearing1139322endearing
fearing113520032__fearing
inferring1338612inferring
nearing83020332_n_earing
uncaring11312842un_caring
unceasing1239652unceasing
undaring10412752un_daring
unerring9311272un_erring
unfading1347692unf_ading
unfeeling1337112unfeeling
unfencing1545952unfencing
unleading1138672unleading
unlearning1144712unlearning
unmeaning1237952unmeaning
unsealing10711042unsealing
unseaming1278112unseaming
unseating10713202unseating
unsparing1237712unsparing
unswearing1444412unswearing
unweaving1636132unweaving
upbearing1435032upbearing
uprearing1238372uprearing
uptearing1236102uptearing
angering102113803ange_ring
annealing1047453annealing
appearing1436893appearing
bearing103624773__bearing
blearing113111943_blearing
buffering1835223buffe_ring
bunkering16207103bunke_ring
clearing113014883_clearing
conferring1648743conferring
defeating142311973defeating
deferring1436143deferring
dogearing1235763dogearing
earing75235483___earing
enfacing1467293enf_acing
enfevering1743863enfevering
enflaming1545633enflaming
enframing1546113enframing
ensnaring1046383ensnaring
entering91920053ente_ring
faring105231283__f_aring
feasing113916653__feasing
feazing205411443__feazing
flaring114116803__flaring
gearing92818843__gearing
hearing113324163__hearing
hungering14187683hunge_ring
hunkering17227123hunke_ring
infecting15109673infecting
infesting13109513infesting
inflaming1546263inflaming
inflating13310443inflating
inhering12913713inhe_ring
insnaring1046313insnaring
interring10315423interring
inweaving1644773inweaving
kneading1436373kn_eading
nonbearing1346453nonbearing
offering1536393offe_ring
outhearing1438443outhearing
outwearing1437183outwearing
rearing83128783__rearing
referring1338033referring
regearing112211413regearing
rehearing132211763rehearing
retearing102214253retearing
rewearing132310703rewearing
searing83330923__searing
shearing123915903_shearing
smearing113511753_smearing
snaring83920953sn__aring
sneaking133211093sn_eaking
sneaping11349493sn_eaping
sneering93414503sn_eering
spearing113216103_spearing
suffering1637293suffe_ring
sundering11312323sunde_ring
swearing123711443_swearing
tearing84021493__tearing
ulcering1139333ulce_ring
umbering1399433umbe_ring
unabating1246753unabating
unaging9510933un__aging
unarming1138623un__arming
unbaling11310683un_baling
unbarring1236063unbarring
unbeing1039373unbe__ing
unbelting1237663unbelting
unbending1337463unbending
unbracing1437023unbracing
unbraking1636933unbraking
uncaging1268713un_caging
uncaking1539463un_caking
uncasing11511003un_casing
unchairing1644603unchairing
uncharging1744393uncharging
uncharming1844523uncharming
uncoating12611923uncoating
uncrating12813183uncrating
uncreating13310473uncreating
underling111514613underling
underwing141410883underwing
undraping1337333undraping
undrawing1436903undrawing
unearthing1454373un_earthing
unendearing1343043unendearing
unending10239943un_ending
unfailing1337453unfailing
unfeared121511013unfear_ed
unfearful1552303unfearful
unfettering1543703unfettering
unfitting1336423unfitting
unfixing1935683unf_ixing
unflagging1642973unflagging
unfolding1436063unfolding
unfreeing1345103unfreeing
unfreezing2343343unfreezing
unfurling1335763unfurling
ungazing1936033un_gazing
unguarding1343533unguarding
unhairing1335953unhairing
unheeding1446103unheeding
unhelming1535493unhelming
unlacing1148653un_lacing
unlading1058863un_lading
unlaying1258363un_laying
unlearn735953unlear_n_
unlearns844453unlear_ns
unlearnt846403unlear_nt
unleashing1444463unleashing
unloading1137193unloading
unmaking1538133un_making
unmeshing1595933unmeshing
unmewing1485913unme_wing
unmitring1245263unmitring
unmooring1255813unmooring
unnerving1336633unnerving
unpaying1456943un_paying
unpegging1443863unpegging
unpenning1236183unpenning
unpleasing1344773unpleasing
unquaking2354593unquaking
unreeling1038983unreeling
unreeving1336213unreeving
unresting10311133unresting
unretiring1145303unretiring
unrewarding1642893unrewarding
unsaying1288153un_saying
unseeing988293unse_eing
unselling10810333unselling
unsetting1088993unsetting
unsewing1287433unse_wing
unsexing1686853unse_xing
unsnarling1143913unsnarling
unspeaking1744423unspeaking
unstating10711213unstating
unstring9312093un_string
unteaching1645493unteaching
untiring9312003un_tiring
untreading1247563untreading
unvarying1644503un_varying
unveiling1337723unveiling
unwaning1238133un_waning
unwearied1336763unwearied
unweeting1336473unweeting
upheaping1743853upheaping
upheaving1843803upheaving
upleaping1434363upleaping
upsoaring1244513upsoaring
upstaring1235963upstaring
ushering1258923ushe_ring
uttering91613083utte_ring
wafering15208893wafe_ring
wearing113318863__wearing

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 Limit1486411796.95321378.0
3Display Results1791790.0762355.3
 (SQL Overall)1786911797.45223978.9
 
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.