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

358 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
opiating1141009(None) 
aviating12311022aviating
epilating12310972epilating
expiating1938542expiating
foliating1339252foliating
obviating1545052obviating
omitting11217742omitting
operating12313722operating
opining10311742opi_ning
oppilating1544862oppilating
opting94514402op__ting
orating83520322o_rating
oxidating1845052oxidating
pirating11314512_pirating
pitting103618872_pitting
plating103823072_plating
pointing112813682pointing
prating103424452_prating
sopiting11310762sopi_ting
spirting112913632spirting
spiting103917622spi_ting
spitting113012322spitting
updating1236592updating
uprating11311112uprating
abating10413973_abating
ablating11312003ablating
aerating92821003aerating
agisting1038243agisting
agitating1138863agitating
airting83616303_airting
aliasing9310073aliasing
animating12312513animating
aspirating1348363aspirating
awaiting1238273awaiting
baiting103918883bai_ting
bating95132253__bating
beating104326873_beating
berating113220763berating
biasing103512453_biasing
biting95321823_bi_ting
bitting103717293_bitting
bleating113514503bleating
bloating113512813bloating
bloviating1643813bloviating
boating103721303_boating
borating113414503borating
cheating144014523cheating
citing94220183_ci_ting
cleating113518143cleating
coating103525313_coating
cogitating1447213cogitating
collating12312783collating
combating16310163combating
copulating1549373copulating
crating103725203_crating
creating113921953creating
curating11314293curating
dating85326483__dating
debating123213733debating
delating103119603delating
depicting1537813depicting
depilating1439193depilating
derating103222283derating
deviating14311083deviating
dialing94318173_dialing
dieting93616833_dieting
dilating102714913dilating
dinting93520553_dinting
doating93816863_doating
dominating1449403dominating
donating10311803donating
drifting13338733drifting
eating75134403__eating
editing9313133edi_ting
elating83423083_elating
emitting112410353emitting
equating18310113equating
estating92614993estating
evicting1437483evicting
eviting11511373evi_ting
existing1639073existing
exiting15311393exi_ting
fainting123312163fainting
fating105328673__fating
feinting123410833feinting
filiating1339253filiating
fisting113818123_fisting
fitting113516563_fitting
fixating1936183fixating
flinting123412343flinting
flirting12319013flirting
fliting113514613fli_ting
flitting123010883flitting
floating123111883floating
foisting122910503foisting
fritting123510703fritting
gaiting93716583gai_ting
gating84826953__gating
gelating103015733gelating
gifting123810893_gifting
girting93113333_girting
gitting93215703_gitting
glinting103210053glinting
gloating102611463gloating
grating93923183_grating
grifting13299263grifting
gritting10309983gritting
gyrating1337453gyrating
hating104929713__hating
heating114024323_heating
heisting123411043heisting
hilting113316893_hilting
hinting113919223_hinting
histing113720373_histing
hitting113017273_hitting
hoisting123610903hoisting
ideating10311703ideating
imitating1238763imitating
iodating1038823iodating
iodinating1246963iodinating
jilting153211743_jilting
jointing16248613jointing
joisting16328503joisting
kilting123213853_kilting
kiting114117093_ki_ting
kitting123214443_kitting
knitting13257023knitting
lapidating1445243lapidating
lariating10311793lariating
legating102313113legating
lifting113313273_lifting
ligating102212283ligating
lilting83515383_lilting
linting83820983_linting
listing84020593_listing
locating11311503locating
luxating1645613luxating
mating94832913__mating
mediating13311203mediating
milting103619123_milting
minting103020813_minting
misting103623383_misting
moating104218153_moating
motivating1646803motivating
mutating112211753mutating
negating102012833negating
nidating1039783nidating
nominating1349503nominating
notating92513343notating
nutating92411953nutating
oaring74225303o__aring
obligating1445813obligating
oiling74925313o_i_ling
oinking123714713o_inking
okaying1534833o_kaying
opaline9412483op_aline
opaquing2042313opaquing
opening1039923op_ening
opiate8513463opiat__e
opiated1039483opiat_ed
opiates9312143opiat_es
oping86322413op___ing
opposing1336383opposing
optative1347653optative
optioning1246553optioning
orbiting1138153orbiting
orienting1038723orienting
orphaning1544993orphaning
oughting1335953oughting
ousting84021353o_usting
outacting1239213outacting
outdating11810863outdating
outeating10814493outeating
outing74128153o__uting
outrating10916403outrating
ovulating1336953ovulating
oxalating1745803oxalating
ozonating1944323ozonating
pacing114522753_p_acing
paging104020403_p_aging
paiking143814813_paiking
paining103920243_paining
painting113614423painting
pairing103716733_pairing
paling93530133_p_aling
panting104025423_panting
paring94236493_p_aring
parting103527383_parting
pasting103826553_pasting
patin76832853_p_atin_
patina86022193_p_atina
patine85328123_p_atine
patins87528783_p_atins
patting103722343_patting
paving124519743_p_aving
pawing124519553_p_awing
paying123722163_p_aying
peacing124117073_peacing
peaking144317693_peaking
pealing104123203_pealing
pelting102917273_pelting
petting103720953_petting
phasing133211673_phasing
piaffing1733923_piaffing
picking163418333_picking
picoting1338883_picoting
piecing12410453_piecing
pieing93917653_pi_eing
pigging123614673_pigging
piing85218833_pi__ing
piking133719643_pi_king
piling95025593_pi_ling
pilling103722563_pilling
piloting1139693_piloting
pimping143812123_pimping
pinging113419553_pinging
pining93726533_pi_ning
pinking143918943_pinking
pinning103417853_pinning
piping114017453_pi_ping
pipping113414743_pipping
piquing1935873_piquing
pishing134314373_pishing
pissing103914803_pissing
pithing134014053_pithing
pittings11349123_pittings
pitying132910243_pitying
pivoting1436183_pivoting
placing123815283_placing
plaiting113113513_plaiting
planing103418253_planing
planting113515383_planting
platina94413643_platina
platings113611363_platings
platting114813033_platting
playing133816093_playing
pleating112916053pleating
poinding122510003poinding
poising103617103poi_sing
pomading1437423pomading
populating1547663populating
porting103021783_porting
positing11312303positing
posting105622243_posting
potting103720893_potting
pouting103519943_pouting
praying133717323_praying
printing113216083printing
punting103318443_punting
pupating1337683pupating
putting103218573_putting
quieting18228463quieting
quilting18218713quilting
quirting18238383quirting
quitting18228833quitting
radiating111112133radiating
rating74938703__rating
rebating112418343rebating
redating102620173redating
relating92725443relating
remating112322423remating
repeating122618983repeating
replating122217403replating
rifting113515003_rifting
rioting82716393_rioting
rotating92614553rotating
ruinating1039593ruinating
sainting93215733sainting
satiating10311813satiating
sating74735453__sating
seating84130683_seating
sedating103014113sedating
seriating10916403seriating
shifting152910383shifting
shirting123213613shirting
shitting123212663shitting
sifting113014593_sifting
silting83320483_silting
siting74126623_si_ting
sitting83519633_sitting
skating123613853_skating
skirting13289393skirting
skiting123812503ski_ting
slating83724653_slating
slitting93012583slitting
smiting103014443smi_ting
solating9315593solating
solvating1336443solvating
sonicating1348313sonicating
spacing123614493sp_acing
spading113114383sp_ading
spaeing103413543sp_aeing
sparing104823873sp_aring
spatting113111763spatting
spaying133014623sp_aying
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
speciating1548123speciating
spicing123914533spi_cing
spieling113212523spieling
spiering112713353spiering
spiffing17237083spiffing
spiking144312883spi_king
spiling102919703spi_ling
spilling113113943spilling
spinning113310813spinning
spiraling1237953spiraling
spiring103918183spi_ring
spiriting1238413spiriting
splatting1235983splatting
splaying14219303splaying
splinting1238193splinting
splitting1236563splitting
spoliating1366963spoliating
sporting112415463sporting
spotting112812093spotting
spouting113511953spouting
spraying14299883spraying
sprinting12310033sprinting
spurting113111633spurting
stating83725163_stating
stilting93312403stilting
stinting93415743stinting
striating10914193striating
suiting83419003sui_ting
supinating1357833supinating
sweating123213023sweating
tainting93613583tainting
tilting83417103_tilting
tinting84620603_tinting
toiting83217093toi_ting
treating92519613treating
triaging102610543triaging
twisting12427813twisting
twitting12307223twitting
uniting8315823uni_ting
upcasting1434823upcasting
updarting1334333updarting
upgazing2133313upgazing
uplifting1534963uplifting
uptilting1234713uptilting
upwafting1842063upwafting
urinating10310653urinating
vacating14310363vacating
variating13310953variating
vialing113614163_vialing
vitiating1338413vitiating
vomiting1437733vomi_ting
waisting123615213waisting
waiting113618953wai_ting
whisting15329543whisting
whiting143311303whi_ting
wilting113515913_wilting
wisting113519743_wisting
witing103522823_wi_ting
witting113417063_witting
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 Filter1786911461620.420425454.8
2DLD Change Limit1461623586.47022590.7
3Display Results3583580.1562294.9
 (SQL Overall)1786913587.04625360.6
 
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.