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

167 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
urinating1031065(None) 
ruinating1039591ruinating
marinating13410272marinating
printing113216082prin_ting
pronating12313762pronating
ruminating1348142ruminating
supinating1357832supinating
urination9312172urination
urinations10310692urinations
urinative1247652urinative
urticating1347352urticating
acuminating1645803acuminating
agitating1138863agitating
alienating1147233alienating
animating12312513animating
arointing1049363aroin_ting
aviating12311023avi_ating
brigading1445143brigading
bringing123011273brin_ging
brining103216473brin__ing
bromating1439183bromating
brominating1696093brominating
coronating13410173coronating
crating103725203cr__ating
creating113921953cr_eating
cremating14312203cremating
criminating1646853criminating
cringing123311383crin_ging
crinkling16145863crinkling
culminating1645733culminating
curating11314293cur__ating
dilating102714913_dilating
dinting93520553_din_ting
dominating1449403dominating
donating10311803_donating
drifting13338733dri_fting
drinking14308913drin_king
emanating1239003emanating
epilating12310973epilating
fainting123312163fain_ting
feinting123410833fein_ting
fixating1936183_fixating
flinting123412343flin_ting
fluorinating1653633fluorinating
frighting1736023frighting
fringing133010903frin_ging
fritting123510703fri_tting
fronting12310443fron_ting
fulminating1744683fulminating
fumigating1744653fumigating
furcating1537783fur_cating
furnacing1543713fur_nacing
geminating1447763geminating
germinating1546173germinating
glinting103210053glin_ting
gradating1237323gradating
granting103514523gran_ting
grating93923183gr__ating
grifting13299263gri_fting
grimacing1544033grimacing
grinding1139863grin_ding
grinning1037863grin_ning
gritting10309983gri_tting
grunting10269583grun_ting
herniating1445983herniating
hinting113919223_hin_ting
imitating1238763imitating
iodinating1246963iodinating
irrigating1245953irrigating
irritating1146293irritating
jointing16248613join_ting
jubilating2045233jubilating
laminating1348733laminating
lariating10311793lari_ating
ligating102212283_ligating
linting83820983_lin_ting
lubricating1644713lubricating
marginating1545893marginating
marinading1445613marinading
minting103020813_min_ting
minuting1139723_minuting
mutilating1349083mutilating
nidating1039783_nidating
nominating1349503nominating
opiating11410093opi_ating
orating83520323or__ating
orientating1245773orientating
orienting1038723orienting
originating1344903originating
oxidating1845053oxidating
ozonating1944323ozonating
paginating1447533paginating
painting113614423pain_ting
patinating1339883patinating
phonating1537813phonating
pirating11314513_pirating
pointing112813683poin_ting
prating103424453pr__ating
predating13514653predating
priesting1239483priesting
prinking153212453prin_king
printings12268103prin_tings
probating14311193probating
prorating12314283prorating
ranting84025413_ran_ting
rating74938703_r__ating
rebating112418343_rebating
redating102620173_redating
relating92725443_relating
remating112322423_remating
renaming11313693_renaming
renting84026853_ren_ting
resinating11313733resinating
rifting113515003_ri_fting
righting132610853_righting
ringing93521283_rin_ging
rinning83216743_rin_ning
rinsing82516113_rin_sing
rioting82716393_ri_oting
rivaling1239913_rivaling
riveting12139443_riveting
rotating92614553_rotating
rubricating1645103rubricating
ruination9311273ruination
ruinations1039603ruinations
ruining83514883ruin__ing
sainting93215733sain_ting
seriating10916403seri_ating
sinuating1039683_sinuating
sprinting12310033sprin_ting
stinting93415743stin_ting
striating10914193stri_ating
surnaming1245143sur_naming
tainting93613583tain_ting
terminating1447353terminating
tincting1148883_tincting
tinting84620603_tin_ting
treating92519613tr_eating
triaging102610543tri_aging
trindling1137133trindling
trining82919213trin__ing
trinketing1544153trinketing
truanting1035603truanting
truncating1344233truncating
ultimating1386803ultimating
ululating1036643ululating
unabating1246753unabating
unaging9510933u__naging
uncoating12611923uncoating
uncrating12813183uncrating
uninviting1443203uninviting
uniting8315823u__niting
unseating10713203unseating
unstating10711213unstating
updating1236593u_pdating
uprating11311113u_prating
uprighting1743463uprighting
urinaries949203urinaries
urinate7315363urinat__e
urinated9311613urinat_ed
urinates8314133urinat_es
urinator847843urinat_or
urinators947633urinators
variating13310953vari_ating
wringing13279623wrin_ging
wrinkling17144953wrinkling
writing113713893wri__ting

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.436409841.7
2DLD Change Limit1486411676.56322648.3
3Display Results1671670.0762197.4
 (SQL Overall)1786911677.07525256.7
 
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.