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

135 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
unbelting123766(None) 
unbolting1236451unbolting
belting104119132__belting
unbaling11310682unbal_ing
unbearing1239352unbearing
unbeing1039372unbe__ing
unbending1337462unbending
unhelming1535492unhelming
unresting10311132unresting
unseating10713202unseating
unselling10810332unselling
unsetting1088992unsetting
unweeting1336472unweeting
abetting1158293_abetting
aneling82719503an_el_ing
angeling102811733angel_ing
beating104326873__beating
belling103825073__belling
beltings11369253__beltings
belying133612443__belying
besting104923923__besting
betting103921403__betting
bolting104416763__bolting
felting113515213__felting
funneling1344513funnel_ing
funnelling1444243funnelling
inbeing1038333inbe__ing
incenting12912063incenting
incepting1489293incepting
indenting11911263indenting
infecting15109673infecting
infesting13109513infesting
ingesting11129623ingesting
injecting1997693injecting
inletting1087873inletting
inserting10914243inserting
insetting1079283insetting
insulting1038053insulting
inventing13109973inventing
inverting131013223inverting
investing13119393investing
junketing2143093junke_ting
kneeling13287783kneel_ing
knelling13319023kn_elling
labeling11311643label_ing
labelling1238083labelling
libeling1139873libel_ing
libelling1236873libelling
melting103317753__melting
nesting84320443_n_esting
netting84018763_n_etting
nonbetting1345843nonbetting
pelting102917273__pelting
rebelling122111163rebelling
remelting12311703remelting
smelting11339713_smelting
snelling93913563sn_elling
tableting1236353tableting
tunneling1034693tunnel_ing
tunnelling1144383tunnelling
umbering1399433umbe_ring
unabating1246753unabating
unbanning1235893unbanning
unbarring1236063unbarring
unbeaten1038013unbeaten_
unbecoming1743093unbecoming
unbelief1346773unbel_ief
unbelieving1752263unbelieving
unbelt83015693unbelt___
unbelted1179333unbelt_ed
unbelts9237663unbelt__s
unbendings1443163unbendings
unbenign1142533unbe_nign
unbinding1336513unbinding
unbottling1343133unbottling
unbowing1436993unb_owing
unboxing1836113unb_oxing
unbracing1437023unbracing
unbraking1636933unbraking
unbudging1443793unbudging
unbuilding1443673unbuilding
unceasing1239653unceasing
uncoating12611923uncoating
uncrating12813183uncrating
uncreating13310473uncreating
underling111514613underling
underlying15136373underlying
undertint10414863undertint
underwing141410883underwing
undulating1247143undulating
unending10239943un_ending
unerring9311273un_erring
unfearing1338883unfearing
unfeeling1337113unfeeling
unfencing1545953unfencing
unfitting1336423unfitting
unfolding1436063unfolding
ungluing1035863un_gluing
unhatting1335873unhatting
unheeding1446103unheeding
uniting8315823un__iting
unleading1138673unleading
unmeaning1237953unmeaning
unmeshing1595933unmeshing
unmewing1485913unme_wing
unmolding1335823unmolding
unnerving1336633unnerving
unpegging1443863unpegging
unpenning1236183unpenning
unpiling1139753unpil_ing
unquoting1944763unquoting
unreeling1038983unreeling
unreeving1336213unreeving
unrelenting1244423unrelenting
unrolling1078563unrolling
unrooting1098833unrooting
unsealing10711043unsealing
unseaming1278113unseaming
unseeing988293unse_eing
unsettling1144433unsettling
unsewing1287433unse_wing
unsexing1686853unse_xing
unshelling1445593unshelling
unsling8313643un_sl_ing
unstating10711213unstating
unveiling1337723unveiling
unweaving1636133unweaving
unwilling1337163unwilling
unwitting1335583unwitting
unyielding1542473unyielding
upbearing1435033upbearing
upsetting1275563upsetting
uptilting1234713uptilting
upwelling1535233upwelling
welting113615313__welting

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.406440125.6
2DLD Change Limit1486411357.23320550.4
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.68523251.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.