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

110 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
viremic143615(None) 
viremia1246081viremia
eirenic939002eirenic
irenic8311102_irenic
uremic103410512_uremic
viremias1345872viremias
anaemic1149903anaemic
anemic102713693_anemic
areic73219393_are_ic
atresic9310003atresic
atretic9313923atretic
bireme10310143birem_e
biremes1138773biremes
bromic122412693_bromic
ceramic1339823ceramic
chemic153012093_chemic
chromic1639863chromic
copremic1645453copremic
coremia11310363coremia
cretic102816283_cretic
demic105119193__demic
dermic114511913der_mic
dieretic1148763dieretic
dilemmic1542873dilemmic
dimeric12310013dimeric
dineric10310973dineric
dioramic1346763dioramic
disomic1238763disomic
diuretic1146993diuretic
eidetic1039743eidetic
emic86422753___emic
endemic1237893endemic
epidemic1545303epidemic
filmic13348453fi_lmic
firelit10310863firelit
fireman1249333fireman
firemanic1653973firemanic
firemen1238773firemen
formic13310453for_mic
haemic133210083_haemic
hemic125718623__hemic
heretic12314833heretic
irenics937833_irenics
iridic9328743_iridic
iritic83213823_iritic
ironic8313773_ironic
karmic1438113kar_mic
keramic1537233keramic
kinesic13257023kinesic
kinetic13209173kinetic
lexemic1844283lexemic
lithemic1545593lithemic
miasmic1335743miasmic
mimetic1338653mimetic
mimic111414323mi__mic
paretic113016673paretic
phrenic1438773phrenic
piratic11314293piratic
polemic13311253polemic
premie103617993_premie
premix173710333_premix
pyaemic1645873pyaemic
pyemic1537893_pyemic
pyretic143210783pyretic
pyrexic21235353pyrexic
racemic1336983racemic
relic74623363__relic
remit75737223__remit
remix145916553__remix
reremice1246023reremice
sapremic1445333sapremic
sememic1336503sememic
spermic1338523spermic
taxemic1835243taxemic
terebic1137983terebic
thermic1439333thermic
tonemic11310173tonemic
totemic1137533totemic
toxemic1845593toxemic
trisemic1245193trisemic
trismic1137483trismic
uraemic1156543uraemic
ureic74514463_ure_ic
uremia82910893_uremia
uretic82914353_uretic
urinemic1244163urinemic
valeric1238303valeric
veridic1338143veridic
vermeil1285223vermeil
vermin113414523ver_min
vermis114214963ver_mis
viatic11311453vi_atic
vibronic1545133vibronic
vinic10314973vi__nic
vinylic1543883vinylic
virelai1045593virelai
virelais1146413virelais
virelay1335943virelay
vireo84816453vire__o
vireos94212453vire_os
vires84529683vire__s
virgin1038083vir_gin
virid94116043vir__id
viroid10411523vir_oid
virosis1039023virosis
vitamin1237423vitamin
vitric112510113vi_tric
vivific1843363vivific
wireman1237843wireman
wiremen1236903wiremen

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.436409841.7
2DLD Change Limit1340271106.67320085.0
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.15524974.3
 
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.