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

244 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
vitric11251011(None) 
citric102812301citric
nitric82512061nitric
vitrics12198551vitrics
citrin82615402citrin
iatric8312152iatric
lithic1139492lithic
metric10314672metric
nitrid72812232nitrid
nitril62511532nitril
picric12309922picric
vatic10316422vat_ic
viatic11311452viatic
vibrio1136222vibrio
vinic10314972vi_nic
virid94116042vi_rid
vitrain1038942vitrain
vitrify1645002vitrify
vitrine102511362vitrine
vitriol1045692vitriol
yttric1145432yttric
agaric93513623agaric
amtrac10109123amtrac
antic75728863ant_ic
anuric8812093anuric
aortic8316613aortic
astrict9614783astrict
atria56022333_atria
atrip75315743_atrip
attic75618353_attic
attrit6315743attrit
auric74521723_auric
aviatic1239243aviatic
aviatrice1443073aviatrice
aviatrix1842133aviatrix
avionic1237693avionic
baric96125693_baric
bionic103614573bionic
biopic123710673biopic
biotic103816603biotic
bistroic1246383bistroic
boric98024223_boric
butyric1445123butyric
capric12411793capric
centric11312393centric
ceric94023093_ceric
choric133515893choric
cirri7710723cirri_
citral81113883citral
citrine92514023citrine
citrins92614363citrins
citron83112983citron
citrus83610913citrus
civic123412543ci_vic
cleric10612133cleric
clitic103315053clit_ic
clitoric1246603clitoric
critic103616813crit_ic
cupric1249113cupric
daric85623113_daric
daturic1047003daturic
dimeric12310013dimeric
dimetric1348643dimetric
dineric10310973dineric
dioptric1345623dioptric
district11413873district
editrix1543633editrix
enteric9314213enteric
estrin6315923estrin
ethic101511223_ethic
etic66123953_et_ic
fabric1337833fabric
ferric1139993ferric
fibril1137163fibril
fibrin1138533fibrin
filmic13348453filmic
fistic11812573fistic
gastric1038623gastric
gittin72910553gittin
gothic1237783gothic
historic1388943historic
hydric15227953hydric
icteric1138023icteric
ictic9311793_ictic
iodic84816743_iodic
ionic74622653_ionic
irid55927163_i_rid
iris45732543_i_ris
iritic83213823irit_ic
italic839903_italic
latria62313583latria
libri74610113libri_
limbic12528723limbic
limnic10418833limnic
liri45128253li_ri_
litai55216363litai_
lithia939333lithia
litotic939233litotic
litre55421463litr_e
litres65220393litres
liturgic1142563liturgic
lotic76420663lot_ic
lubric1097983lubric
lyric104512723_lyric
lytic104513033lyt_ic
mantric11311333mantric
matrix1539833matrix
metrics11312363metrics
midrib1138233midrib
mimic111414313mi_mic
miotic103715743miotic
miri66730363mi_ri_
mirin75023143mi_rin
mitis75425983mit_is
mitotic1139703mitotic
mitral81314323mitral
mitre75522423mitr_e
mitred94414343mitred
mitres83922073mitres
mitring103514143mitring
motoric11312223motoric
mythic1637273mythic
naric76824173_naric
niobic1037233niobic
niterie7313743niterie
nitid61817833nit_id
nitpick1543783nitpick
nitre57519683nitr_e
nitres65519333nitres
nitride82811243nitride
nitrids8269633nitrids
nitrify1335793nitrify
nitrile73011373nitrile
nitrils72810703nitrils
nitrite72314463nitrite
nitro54914353nitr_o
nitrolic1046813nitrolic
nitros64214123nitros
nitwit938593nitwit
nutria639903nutria
ontic74418573ont_ic
optic93715183opt_ic
ostrich1238663ostrich
otic66624813_ot_ic
otitic83112683otitic
outrig72812843outrig
pianic103714123pianic
picnic123410263picnic
pionic103515953pionic
putrid9311163putrid
pyric123815073_pyric
retrim83514873retrim
ricrac1037013ricrac
rubric1097823rubric
satiric939243satiric
satyric1237493satyric
sialic8313633sialic
steric8317063steric
stoic7317243_stoic
stria55723203_stria
strick124813203_strick
strict84821043_strict
strip77524333_strip
tantric939573tantric
tetri52716453tetri_
tetris62816293tetris
thoric114314033thoric
tic56343463__t_ic
titanic968543titanic
titbit839813titbit
titi47130613tit_i_
titis56023813tit_is
titmice1144663titmice
titre54619393titr_e
titres64718933titres
tittie63213153tittie
toric76529313_toric
triac74116373__triac
trice75127493__trice
trick115420693__trick
trig55528163__trig
trim65329513__trim
trio45233343__trio
trip66830393__trip
untrim8310673untrim
uric63624933__uric
uveitic1244683uveit_ic
valeric1238303valeric
varia85824203v_aria
varix154313503v_arix
viatica1245863viatica
vibrion1245253vibrion
vibrios1235803vibrios
vibronic1545133vibronic
victim1337683victim
victoria1346313victoria
vier75428153vier__
viers85621953vier_s
vigia94813273vi_gia
vigil94313003vi_gil
villi86517853villi_
vinylic1543883vinylic
violin9311983violin
viral86419593vi_ral
viremic1436153viremic
vireo84816453vi_reo
vires84529683vi_res
virga9310253vi_rga
virgin1038083virgin
virile9313433vi_rile
virion9310683vi_rion
virl76224473vi_r_l
virls85618603vi_rls
viroid10411523viroid
virtu85314093vi_rtu
virtue9358673virtue
virtus94310143virtus
virus85316843vi_rus
viscid1237473viscid
visit8320963vi_sit
vita75828523vit__a
vitae84217633vit_ae
vital84819673vit_al
vitals94514303vitals
vitamin1237413vitamin
vitrains1138283vitrains
vitrines112610913vitrines
vitriolic1443033vitriolic
vitriols1145053vitriols
vitta85015173vit_ta
vittae93910993vittae
vittle94711753vittle
vivaria1346983vivaria
vivid125112313vi_vid
vivific1843363vivific
vizir17359393vi_zir
vizirs18306713vizirs
voltaic1245453voltaic
within123611383within
xeric144315663_xeric
yttria954803yttria
zincic1935903zincic
ziti136022373zit_i_
zitis145815583zit_is

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162447.56314903.6
3Display Results2442440.0803050.0
 (SQL Overall)1786912447.78322959.1
 
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.