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 “oriel” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
oriel5492042(None) 
ariel55228971ariel
oriels64914621oriels
riel46432381_riel
ariels65119372ariels
aril45843022ari_l
artel56122742artel
bordel94514572bordel
brie65837902brie_
brief105422602brief
brier74527402brier
bries74942152bries
brill74819952brill
chiel104918972chiel
corbel103715972corbel
cormel103815602cormel
cornel84020052cornel
creel75121482creel
cried84624282cried
crier74724462crier
cries75438402cries
cruel74815902cruel
diel59034602_diel
dories75232362dories
dorsel75315502dorsel
dried75321382dried
drier64423962drier
dries64733672dries
drill64718262drill
drivel105110382drivel
fried95322912fried
frier85225842frier
fries85535602fries
frill84917562frill
gorier73719372gorier
grief95319782grief
grill64617892grill
gruel66014742gruel
krill94213642krill
lories64933042lories
morel75729092mor_el
morsel85815892morsel
oil37452052o_i_l
oorie53026362oorie_
oral47638122or_al
orbed85516192orbed
orbier839992orbier
ordeal779252ordeal
order65019362order
ore36661832or_e_
ores46056682or_es
orgies72316092orgies
oribi7311092oribi
orient6322532orient
oriole6814292oriole
orle45630462orle_
orles55326212orles
ormer75218372ormer
osier53518012osier
ourie54027292ourie_
ousel55222402ousel
ouzel144612322ouzel
pried84426862pried
prier75027762prier
pries74339532pries
prill74117942prill
reel45240532_reel
rial45938092_rial
riels55121332_riels
rile45650532_rile
rill45140902_rill
roil46235292roi_l
rowel84721412rowel
shiel811023772shiel
sorel56231442sor_el
sorrel6413542sorrel
spiel74623912spiel
tories65435882tories
trial54926352trial
tried65026912tried
trier54328532trier
tries55742812tries
trill55122932trill
triol55521362triol
urial54823022urial
wried95518562wried
wrier84521752wrier
wries85827742wries
zoril143916692zori_l

Search took 2 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 Filter178691538000.0961861364.6
2DLD Change Limit53800891.73331044.4
3Display Results89890.0165562.5
 (SQL Overall)178691891.84596851.5
 
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.