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

159 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
orienting103872(None) 
friending1495552friending
orientating1245772orientating
priesting1239482priesting
printing113216082pri_nting
renting84026852_r_enting
reorienting1246352reorienting
tormenting1345692tormenting
absenting1236993absenting
accenting1487823accenting
agenting1039383_agenting
alienating1147223alienating
aliening91510893alien_ing
alimenting1344503alimenting
argentine1047893argentine
arointing1049363arointing
aroynting1344633aroynting
arresting1038633arresting
assenting1038163assenting
briefing1436943brie_fing
bringing123011273bri_nging
brining103216473bri_n_ing
cementing1438763cementing
commenting1749173commenting
consenting13313213consenting
contenting13313323contenting
conventing16311543conventing
correcting15199303correcting
corseting12312173corse_ting
creating113921953cr_eating
cresting114017043cr_esting
cringing123311383cri_nging
dementing13311043dementing
denting94422183__denting
dieting93616833_die_ting
dinting93520553_di_nting
directing1338823directing
disorienting14155653disorienting
drifting13338733dri_fting
drinking14308913dri_nking
erecting112415063er_ecting
fainting123312163fai_nting
feinting123410833fei_nting
fermenting1646823fermenting
flinting123412343fli_nting
fomenting1537233fomenting
foresting13311363for_esting
forfeiting1744133forfeiting
forfending1844183forfending
forgetting1544663forgetting
fretting122711523fr_etting
frighting1736023frighting
fringing133010903fri_nging
fritting123510703fri_tting
fronting12310443fr_onting
garmenting1445483garmenting
glinting103210053gli_nting
granting103514523gr_anting
greening103112533green_ing
greenling1136753greenling
greenwing1434693greenwing
greeting103112353gr_eeting
grieving1385893grie_ving
grifting13299263gri_fting
grinding1139863gri_nding
grinning1037863gri_nning
gritting10309983gri_tting
grunting10269583gr_unting
henting113719653__henting
hinting113919223_hi_nting
incenting12912063incenting
indenting11911263indenting
inventing13109973inventing
jointing16248613joi_nting
lamenting1237693lamenting
linting83820983_li_nting
margenting1446153margenting
minting103020813_mi_nting
misorienting15154963misorienting
mordanting1444003mordanting
objecting2144053objecting
obtesting1245883obtesting
obverting1536303obverting
offending1744093offending
oinking123714713o_i_nking
omening10310093o_men_ing
omitting11217743omi_tting
opening1039923o_pen_ing
opiating11410093opi_ating
opining10311743opi_n_ing
orating83520323or__ating
orbiting1138153or_biting
ordering1039353orde_ring
orient6322533orient___
oriental848483orient_al
orientals946903orientals
orientate946513orientate
oriented937483orient_ed
orienteer943213orienteer
orienteering1352613orienteering
orienter838313orient_er
orienters937613orienters
orients7311583orient__s
originating1344903originating
ornamenting1452563ornamenting
outeating10814493outeating
oxidating1845053oxidating
painting113614423pai_nting
parenting12611583parenting
patenting1248943patenting
pointing112813683poi_nting
portending1446193portending
precenting151012153precenting
preening113115843preen_ing
presenting131013023presenting
preventing161210263preventing
prinking153212453pri_nking
printings12268103pri_ntings
quieting18228463quie_ting
ranting84025413_r_anting
reesting93118273_reesting
reining84425323_rein_ing
reinking13311023_reinking
relenting102716773relenting
rending93924263_r_ending
repenting122316553repenting
rerenting102617663rerenting
resenting102619293resenting
resting85031183_r_esting
retting83425883_r_etting
riesling939013_riesling
rifting113515003_ri_fting
righting132610853_righting
ringing93521283_ri_nging
rinning83216743_ri_nning
rinsing82516113_ri_nsing
rioting82716393_ri_oting
ripening1138573_ripen_ing
riveting12139443_riveting
rivetting13256413_rivetting
sainting93215733sai_nting
scenting113212813_scenting
sklenting1475123sklenting
sprinting12310033spri_nting
stinting93415743sti_nting
tainting93613583tai_nting
tenting84621153__tenting
tinting84620603_ti_nting
treating92519613tr_eating
trending103012833tr_ending
trining82919213tri_n_ing
trisecting1345503trisecting
truanting1035603truanting
urinating10310653urinating
venting114218093__venting
worsening1345553worsen_ing
wresting123811833wr_esting
wringing13279623wri_nging
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.186960704.3
2DLD Change Limit1486411597.11320897.1
3Display Results1591590.0602650.0
 (SQL Overall)1786911597.35924282.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.