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

156 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
cistron929988(None) 
cistrons102710621cistrons
citron83112981ci_tron
biotron937292biotron
bistro8339942bistro_
bistros92810982bistros
cistern93310702cistern
cistronic1345472cistronic
citrin82615412ci_trin
citrons92913222ci_trons
diatron839282diatron
intron64215022_intron
piston83515922pist_on
aileron739833aileron
bastion9312473bastion
bestrow1237253bestrow
bestrown1345203bestrown
bicron103710773bi_cron
biotrons1037233biotrons
bison75716983bis__on
bistort91216523bistort
bistre83815023bistr_e
bistred103311853bistred
bistres94017213bistres
bistroic1246383bistroic
boston8513043bost_on
caisson936593cais_son
caldron1038153caldron
caltrop11267643caltrop
calutron1045553calutron
canton85722993cant_on
caption113513693caption
carton84522663cart_on
cartoon94114463cartoon
casern84713313caser_n
castor84418533cast_or
castors94919443castors
cation83925503c_ation
caution93013523caution
cession939813cession
cestoi84511953cest_oi
cestos84718093cest_os
chevron1575783chevron
chiton112612393chit_on
cicero1048503cicero_
cicerone1247523cicerone
ciceroni1244853ciceroni
ciceros1158583ciceros
cinerin9313823cinerin
cion613330913ci___on
cisco95112133cis_co_
ciscos104711133cis_cos
cist67244963cist___
cisted95217523cist_ed
cisterna10376363cisterna
cisterns10369573cisterns
cists76624533cist__s
cistus84611343cist_us
citation10314363citation
cithren12306593cithren
citral81113893ci_tral
citric102812313ci_tric
citrine92514023ci_trine
citrins92614363ci_trins
citrous93112993ci_trous
citrus83610923ci_trus
cittern9339143cittern
coistrel1046743coistrel
coistril1046763coistril
coition9314313coition
control9310693control
copatron1246753copatron
cosmotron1353153cosmotron
costrel9310373costrel
cotton8312993c_otton
craton84517193crat_on
croton84415453crot_on
cryotron1344373cryotron
cuatro838433cuatro_
cuatros938273cuatros
cushion1236403cushion
custom104010273cust_om
custos84014313cust_os
cystein1246053cystein
cyton101511463c_yt_on
destroy1138153destroy
diatrons939613diatrons
diction102313053diction
dipteron1145593dipteron
discrown1445283discrown
distain8313783distain
distort81120333distort
distrain9412243distrain
diuron738573di_uron
elytron1045463elytron
estrin6315923_estrin
estrone7413953_estrone
festoon1037673festoon
fiction122010733fiction
fission1038733fission
gastrin839833gastrin
giron66118993gi__ron
histone10312843hist_one
history1339423history
intro54915853_intro_
introns73515023_introns
intros64215773_intros
iron46728463_i__ron
isogon7227543_isogon
klystron1542523klystron
linuron746513linuron
listen64816813list_en
matron83918313_matron
mesotron1045383mesotron
micron103714283mi_cron
midiron1046003midiron
mikron12318503mi_kron
misgrow1344433misgrow
misgrown1443983misgrown
mission9312743mission
mistbow1443993mistbow
misthrow16134273misthrow
misthrown1793133misthrown
mistook1337153mistook
mistrain10311943mistrain
mistral91013643mistral
natron64116023_natron
neutron737763neutron
niton55418283ni_t_on
nitro54914353ni_tro_
nitros64214123ni_tros
oestrin7312243oestrin
oestrone849973oestrone
patron84018043_patron
pistol83313333pist_ol
pistons93016373pist_ons
pistou83211843pist_ou
piton76121583pi_t_on
plastron1046913plastron
pliotron1044563pliotron
positron1096903positron
ristra6310713ristr_a
ristras7311563ristras
scission1045563scission
sistra639333sistr_a
sistroid947263sistroid
sistrum946563sistrum
strong74914883__strong
strop77422243__strop
strow88920573__strow
strown96812093__strown
stroy87720393__stroy
teston6313303test_on
testoon748373testoon
vision9311313vis_ion
waitron1036333waitron

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.406440125.6
2DLD Change Limit1340271566.94019312.2
3Display Results1561560.0463391.3
 (SQL Overall)1786911567.39224173.6
 
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.