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

108 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
ovulating133695(None) 
adulating1178712adulating
copulating1549362copulating
emulating1239862emulating
modulating1446372modulating
osculating1347372osculating
ovulation1238982ovulation
ovulations1337972ovulations
oxalating1745802oxalating
populating1547662populating
ululating1036642ululating
ablating11311993_ablating
acylating1547553acylating
ambulating1546353ambulating
angulating1247813angulating
aviating12311013av_iating
avulsing1234433avul_sing
canulating1349543canulating
chelating1549353chelating
coagulating1545063coagulating
collating12312753collating
conflating1649993conflating
corelating13511583corelating
cumulating1546343cumulating
curating11314293_curating
deflating142610713deflating
delating103119603_delating
dilating102714903_dilating
divulgating1742303divulgating
educating1337923educating
elating83423083__elating
epilating12310963epilating
equating18310113equ_ating
evaluating1456013evaluating
evulsing1234733evul_sing
exulting1637643exul_ting
fabulating1645513fabulating
faulting12237733faul_ting
fellating1339243fellating
formulating1765033formulating
gelating103015733_gelating
inflating13310443inflating
inoculating1446723inoculating
insulating1139263insulating
isolating1039743isolating
jaculating2047283jaculating
jugulating1943843jugulating
luxating1645613_luxating
maculating1549533maculating
moulting112710313moul_ting
mulcting13246983_mulcting
mutating112211753_mutating
nutating92411953_nutating
obturating1346573obturating
obviating1545053obviating
occulting1445103occul_ting
operating12313723operating
opiating11410093o_piating
oppilating1544853oppilating
orating83520323o__rating
oughting1335953o_ughting
ousting84021353o_u_sting
outacting1239213o_utacting
outdating11810863outdating
outeating10814493outeating
outing74128153o_u__ting
outlasting1137513outlasting
outlawing1337933outlawing
outlaying1338543outlaying
outrating10916403outrating
overacting16310913overacting
overawing16710293overawing
overeating141016523overeating
overhating17910953overhating
overlading1539323overlading
overlaying1738443overlaying
overrating14814183overrating
ovulate1039453ovulat__e
ovulated1237083ovulat_ed
ovulates1148523ovulat_es
ovulatory1544833ovulatory
oxidating1845053oxidating
ozonating1944323ozonating
peculating1549153peculating
plating103823073__plating
postulating1447503postulating
pulsating1236343_pulsating
pupating1337683_pupating
reflating132514713reflating
regulating12310063regulating
relating92725443_relating
replating122217393replating
reslating102516993reslating
sculpting1435003sculpting
simulating1347613simulating
slating83724653__slating
solating9315593_solating
sporulating1445113sporulating
sublating12310983sublating
sulfating1338063_sulfating
tabulating1346413tabulating
tubulating1345583tubulating
undulating1247143undulating
vacating14310343_vacating
valeting1238843_valeting
valuating1338633_valuating
vaulting12227223vaul_ting
violating1337423violating

Search took 10 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.1561145455.1
2DLD Change Limit1486411088.79616898.7
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.99819859.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.