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

169 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
sublating1231098(None) 
ablating11312002_ablating
jubilating2045232jubilating
sibilating1346972sibilating
slating83724652s__lating
solating9315592s_olating
sublation11311012sublation
sublations12410112sublations
subleasing1345522subleasing
subletting1346272subletting
sublimating1675462sublimating
subliming1446542subliming
subwaying1843872subwaying
sufflating1744842sufflating
sulfating1338062sulfating
summating1437942summating
tubulating1345592tubulating
abating10413973_ab_ating
acylating1547573acylating
adulating1178723adulating
ambulating1546373ambulating
bating95132253__b_ating
beating104326873__beating
blading113615363__blading
blaming123515693__blaming
blaring104317113__blaring
blasting114013433__blasting
blatting114111653__blatting
blawing134012753__blawing
blazing193612393__blazing
bleating113514503__bleating
bloating113512813__bloating
boating103721303__boating
bulleting1236643bulleting
butylating1644583butylating
chelating1549363chelating
collating12312783collating
cumulating1546353cumulating
curating11314293cu_rating
debating123213733deb_ating
deflating142610713deflating
delating103119603_delating
dilating102714913_dilating
elating83423083__elating
emblazing2344853emblazing
emulating1239873emulating
epilating12310973epilating
escalating1347093escalating
fabulating1645523fabulating
fellating1339253fellating
furcating1537783furcating
gelating103015733_gelating
imblazing2344063imblazing
inflating13310443inflating
insulating1139263insu_lating
isolating1039743isolating
jugulating1943843jugulating
librating1239053librating
luxating1645613lu_xating
mulcting13246983mu_lcting
mutating112211753mu_tating
mutilating1349083mutilating
nucleating1346943nucleating
nutating92411953nu_tating
osculating1347383osculating
outblazing2245593outblazing
outbleating1444883outbleating
outdating11810863outdating
outeating10814493outeating
outlasting1137523outlasting
outlawing1337933outlawing
outlaying1338543outlaying
outrating10916403outrating
ovulating1336953ovulating
oxalating1745803oxalating
plating103823073__plating
pulsating1236343pulsating
pupating1337683pu_pating
quilting18218713quil_ting
rebating112418343reb_ating
reflating132514713reflating
relating92725443_relating
replating122217403replating
reslating102516993reslating
ruinating1039593ruinating
salting84120793s_al_ting
saluting9310553s_aluting
satiating10311813satiating
sating74735453s___ating
scubaing1335733scub_a_ing
sculpting1435003sculpting
seating84130683s__eating
sedating103014113s_edating
sensating1039253sensating
seriating10916403seriating
serrating10513203serrating
sibling10814423sibl__ing
silting83320483s_il_ting
simulating1347613simulating
sinuating1039683sinuating
situating1038883situating
skating123613853s__kating
slaking123717473s__laking
slanting94115093s__lanting
slatings94011723s__latings
slatting94014233s__latting
slaving113514833s__laving
slaying113316843s__laying
smelting11339713smel_ting
solacing11310133s_olacing
solvating1336443solvating
splatting1235983s_platting
splaying14219303s_playing
spoliating1366963spoliating
stating83725163s__tating
stilting93312403stil_ting
striating10914193striating
subalpine1343553subalpine
subbasin1245393subbasin_
subbasins1344763subbasins
subbing123915583sub__bing
subclassing1653303subclassing
subducing1544573subducing
subducting1644313subducting
subduing1235823sub_duing
subediting1445303subediting
subheading1743793subheading
subjecting2245553subjecting
subjugating2252913subjugating
sublate9315363sublat__e
sublated11311503sublat_ed
sublates10315003sublat_es
subline9316893subl__ine
submarine1347843submarine
submitting1544973submitting
suborning1246683suborning
subring104116263sub__ring
subrogating15164983subrogating
subsiding1346343subsiding
subsisting1345533subsisting
subsuming1444273subsuming
subtitling1344563subtitling
subtracting1645273subtracting
subvening1546033subvening
subverting1666293subverting
sugaring1039053su_garing
suiting83419003su__iting
sulking124514313su_l_king
sullying12328513su_llying
sulphating1644323sulphating
summiting1445793summiting
sunbathing1642933sunbathing
supinating1357833supinating
supplanting1643923supplanting
surfacing1545643surfacing
surnaming1245143surnaming
surtaxing1784143surtaxing
sweating123213023s_weating
tableting1236353tableting
tabulating1346433tabulating
ululating1036643ululating
umlauting1243163_umlauting
unlacing1148653_unlacing
unlading1058863_unlading
unlaying1258363_unlaying
updating1236593_updating
uprating11311113_uprating
vibrating1537483vibrating
violating1337443violating

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 Limit1486411696.81321817.3
3Display Results1691690.0762223.7
 (SQL Overall)1786911697.31224438.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.