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

141 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
strobic113825(None) 
strobil936961strobil
aerobic11310212aerobic
saprobic1445262saprobic
sorbic10310392sor_bic
stoic7317252st_o_ic
strobe84513812strob_e
strobes93813262strobes
strobila1044932strobila
strobile1047032strobile
strobili1044932strobili
strobils1046562strobils
strontic1048122strontic
strophic1569002strophic
tropic103014192_tropic
acronic112814693acronic
acrotic112515543acrotic
aerobia939473aerobia
aerobics1246833aerobics
aprotic112715243aprotic
arabic10312733_arabic
ascorbic1443333ascorbic
atomic104115603at_omic
atonic83420473at_onic
atopic103514143at_opic
atresic9310003atresic
atretic9313923atretic
atrophic1549373atrophic
atropin9311583atropin
bistroic1246383bistro_ic
boronic11311163boronic
bromic122412693_bromic
cerotic11415063cerotic
chromic1639863chromic
chronic14311423chronic
cistronic1345483cistronic
entropic1249693entropic
erotic82620273_erotic
esotropic13126793esotropic
frolic1149203_frolic
heroic113516923hero_ic
ironic8313773_ironic
isotropic1396643isotropic
meropic13310273meropic
microbic1647213microbic
moronic11311863moronic
niobic1037243_niobic
nitrolic1046813nitrolic
parodic122311723parodic
parotic112518043parotic
petrolic1249693petrolic
phobic153010073_phobic
probit103218353_probit
ptotic102713373pt_otic
rabic93817403__rabic
robin74820283__robin
sardonic1147453sardonic
searobin1045713searobin
sermonic1248883sermonic
sodic84917493s__odic
sonic75225293s__onic
soritic91414433soritic
sorosis72611973sorosis
stannic936663stannic
static83118683st_atic
stearic939423stearic
stelic8313083st_elic
stenotic1048083stenotic
steric8317063st_eric
steroid81314873stero_id
sthenic1268903sthenic
stichic1446243stichic
stoai55417873st_oai_
stob66724613st_ob__
stobs75718233st_ob_s
stogie7311323st_ogie
stoics8311113st_o_ics
stolid74213183st_olid
stolonic1047583stolonic
stoolie739723stoolie
stotin63215063st_otin
strain64919573str_ain
strait64025893str_ait
strati63518903strati_
stria55723213str__ia
strick124813203str__ick
strict84821043str__ict
strigil837263strigil
strip77524343str__ip
strobilae1143483strobilae
strobilar1143023strobilar
strobiles1146953strobiles
strobilus1143613strobilus
strode75215973stro_de
stroke105116173stro_ke
stroked124613623stroked
stroker114113523stroker
strokes114316323strokes
stroking132610943stroking
stroll6311603stro_ll
strolls739183strolls
stroma84313073stro_ma
stromal93010593stromal
stromatic13410213stromatic
strong74914883stro_ng
strontia845873strontia
strook10410303stro_ok
strop77422243stro__p
strophe1239143strophe
stroppy14205093stroppy
strops86220383stro_ps
stroud7310383stro_ud
strouds837803strouds
strove95014793stro_ve
strow88920573stro__w
strowed115312143strowed
strowing122310563strowing
strown96812093stro_wn
strows96718273stro_ws
stroy87720393stro__y
stroyed114110863stroyed
stroyer103510783stroyer
stroying122410593stroying
stroys95914603stro_ys
styptic1445453styptic
subtropic1544573subtropic
synodic1347363synodic
terbic10410963_terbic
terebic1137983terebic
thoric114314043_thoric
tonic74727653_t_onic
topic95721503_t_opic
toric76529313_t_oric
toxic145315623_t_oxic
tragic93811553_tragic
trois57226093_tro_is
trophic14311033_trophic
tropics113610653_tropics
tropin83316753_tropin
tyronic1239313tyronic
xerotic16410863xerotic

Search took 7 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.423422437.4
2DLD Change Limit1340271416.20321606.8
3Display Results1411410.0463065.2
 (SQL Overall)1786911416.67226782.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.