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

116 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
oxazine235477(None) 
oxazines2434071oxazines
azine146721412__azine
diazine1738932diazine
examine161510032examine
opaline9412482opaline
topazine1944982topazine
acarine9316003acarine
alanine7316863alanine
aline57243153__aline
amazing1938813amazing
amine75835383__amine
atrazine1748403atrazine
azide155617163__azide
azines155517073__azines
benzine1839343benzine
blazing193612393blazing
bombazine2462683bombazine
brazing193715113brazing
canine83826703_canine
chaine115119223cha_ine
cocaine111315173coca_ine
crazing193914583crazing
cyanine122911513cyanine
dazing175516513_dazing
diamine10311983diamine
diazin1639163diazin_
diazines1838713diazines
diazins1739183diazins
domaine10610503doma_ine
dopamine1346173dopamine
elapine9310673elapine
enamine91214313enamine
etamine91313073etamine
examined18135863examined
examinee17156583examinee
examiner17145463examiner
examines17128793examines
exine125518493ex__ine
famine114318193_famine
fanzine1937123fanzine
fazing194418643_fazing
feazing205411443feazing
flavine1338453flavine
gamine94620153_gamine
gazing174717173_gazing
glazing183611003glazing
gradine93317033gradine
gratine84719193gratine
grazing183514553grazing
guanine8810543guanine
hazing194218553_hazing
hexamine2046873hexamine
hyaline132310723hyaline
imagine1037883imagine
isatine7311763isatine
larine63927043_larine
lawine93316463_lawine
lazing164821473_lazing
magazine2046553magazine
maline84529083_maline
marine84230403_marine
mazing184418973_mazing
monazite1957083monazite
moraine9314573mora_ine
narine63422553_narine
oaring74225303o_aring
ocarina948023ocarina
offline1345783offline
okaying1534833okaying
olefine1038023olefine
oleine6313793o_leine
olivine1038843olivine
online6315843o_nline
oozing163812203o_ozing
opalines10311423opalines
opine77422463o__pine
orating83520323orating
organzine1944203organzine
orpine83914483o_rpine
oscine8311563o_scine
outline72321333outline
ovine86316643o__vine
oxalate1457623oxalate
oxalic1537093oxali_c
oxalis1339223oxali_s
oxalises1538503oxalises
oxide131210953ox__ide
oxidise1545043oxidise
oxidize2444983oxidize
oxime1498433ox__ime
oxlike17307473ox_like
oxytone1744203oxytone
ozone14310613o__zone
patine85328123_patine
praline93019743praline
rapine85023083_rapine
ratine65131823_ratine
ravine95522223_ravine
razing164524543_razing
romaine9512123roma_ine
sabine84020393_sabine
saline65132703_saline
savine94220283_savine
simazine1945363simazine
solanine8311533solanine
sonatine8313323sonatine
sozine15712343_sozine
stanine73417073stanine
thiazine2045253thiazine
toxine133114123tox__ine
triazine1738503triazine
vahine123612113_vahine
valine94623093_valine
wahine123813013_wahine
zine137036153___zine

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271167.15618729.3
3Display Results1161160.0303866.7
 (SQL Overall)1786911167.32624391.3
 
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.