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

88 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
odors6451427(None) 
doors65022131doors
dors56747601_dors
odor55718091odor_
odours7418231odours
adore65723662adore
adores74420712adores
adorn64917092adorn
adorns74212612adorns
ados57633512ado_s
ardors74416862ardors
boors74325012boors
coders95426972coders
codons96119462codons
colors86622372colors
condors104018552condors
cors66656442_cors
docs75631152_docs
dodoes85716102dodoes
dodos75819392dodo_s
doers65225712doers
does56554472_does
dogs66440152_dogs
dolors75115312dolors
dols56943052_dols
doms76239572_doms
donors75115792donors
dons56048702_dons
dooms85321342dooms
door56928512door_
dor47253922_dor_
dore56353302_dore
dork96531462_dork
dorks105724442_dorks
dorm76834622_dorm
dorms85723832_dorms
dorp76028052_dorp
dorps85419222_dorps
dorr56627722_dorr
dorrs65520592dorrs
dorsa64617282_dorsa
dory85836232_dory
dos48062312_do_s
doss56235042_doss
dots55647662_dots
dows85941052_dows
honors94816792honors
idols65514132idols
iodous7311492iodous
kors85933012_kors
moors74923142moors
mors65950062_mors
motors84616592motors
nodous7711322nodous
oars46846032o_ars
oboes75717712oboes
obols73715862obols
odahs95610082odahs
odas57230262od_as
odds68919922od_ds
odeons739022odeons
odes57243242od_es
odious749932odious
odored8399222odored
odorous837662odorous
odour64710472odour
ods47546212od__s
odyls9428652odyls
omers76923192omers
onos46229002ono_s
oohs75220692o_ohs
oops65232672o_ops
oots46446442o_ots
orders74315992orders
ordos65216202ordo_s
ors35750112__ors
ours47237562o_urs
overs85224792overs
oyers87620882oyers
rotors64917932rotors
sodoms989662sodoms
sopors85215192sopors
sordors839982sordors
sudors7311092sudors
tors46157382_tors
udons65411462udons
udos56619902udo_s
vodous1038592vodous

Search took 3 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.0931921408.6
2DLD Change Limit53800881.89028465.6
3Display Results88880.0165500.0
 (SQL Overall)178691881.99989390.2
 
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.