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

183 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
citolas93936(None) 
citola838391citola_
citoles9312551citoles
canolas9313992canolas
cholas114818002c_holas
cibols1039522cibol_s
cicalas1139302cicalas
citole8311502citol_e
citrals91111672citrals
colas75436772c__olas
cupolas11277752cupolas
cutlas8313102cut_las
tolas54532772__tolas
violas93713522vi_olas
acerolas1048053acerolas
aciculas12228563aciculas
aftosas10147153aftosas
aiolis6316843ai_olis
areolas71013863areolas
atlas55821583_at_las
atolls65511353_atolls
biogas94310913bi_ogas
biotas84313923bi_otas
bipolar1145453bipolar
bolas74733763__bolas
cabalas113516003cabalas
caeomas1138403caeomas
cajoles163712103cajoles
callas84526753c_allas
canola8313623canola_
cantalas104013523cantalas
canulas9312853canulas
capitols12247333capitol_s
carols85124983carol_s
carolus94612603carolus
catalase1039223catalase
catalos9414163catalos
catalpas1246733catalpas
catclaw1443973catclaw
catclaws1543633catclaws
catenas9313113catenas
cedulas1058503cedulas
challas124414123challas
chelas113817203c_helas
chimlas1437453chimlas
chitons122611913chito_ns
chitosan1374583chitosan
chitosans1474663chitosans
chola104718033c_hola_
chollas123811353chollas
cholos114716853c_holos
chromas142512693chromas
cibol9512023cibol__
ciboules1244533ciboules
cicadas1235993cicadas
cicala10310053cicala_
cinemas1138043cinemas
cineoles10109403cineoles
cineols9128853cineol_s
cions75222853ci_o_ns
cipolin1148783cipolin
cipolins1238033cipolins
circles1139903circles
citers85022983cit_ers
cites74435593cit__es
citharas13156723citharas
cithers124315773cithers
cities84524853cit_ies
citral81113893cit_ral
citrins92614363citrins
citrons92913223citrons
citrous93112993citrous
citrus83610923cit_rus
clitoral10106463clitoral
clitoris1047873clitoris
coalas87418963c_oalas
coals76129603c__oals
cocas95926573c__ocas
cocoas104915743coco_as
codas84724243c__odas
cola66541393c__ola_
colds85726973c__olds
coles76055063c__oles
cols66553083c__ol_s
colts76633293c__olts
colzas174010513c__olzas
comas95833003c__omas
cools75632633c_ool_s
copulas113811563copulas
corollas1039213corollas
coronas93916913coronas
cottas84615573cot_tas
crapolas1247403crapolas
creoles9913323creoles
cuittles1045903cuittles
cupola10317693cupola_
cutlass938013cut_lass
cutoffs1533603cutoffs
cutouts938033cutouts
cuttles93613923cuttles
cymols1377193cymol_s
cytons111710183cyto_ns
cytoplasm1854623cytoplasm
cytoplast1646663cytoplast
diols65521013di_ol_s
dipolar1056853dipolar
dipoles101013753dipoles
ditas65923673dit__as
eidola737683eidola_
extolls1444603extolls
extols1337683extol_s
fibulas12228563fibulas
fistulas1155403fistulas
gigolos934693gigolos
hilloas104413553hilloas
idols65514133_idol_s
iotas54821113_i_otas
ixoras1337193_ixoras
keitloas1242623keitloas
ketols104210763ketol_s
kiblas1239323ki_blas
kittles113012493kittles
kolas94822233__kolas
ligulas8329173ligulas
lintols7339553lintol_s
lipomas1156443lipomas
litas54923773lit__as
lithias1038823lithias
litoral7610763litoral
litotes7311183litotes
littles73212783littles
metols84115773metol_s
mimosas1136753mimosas
mitoses9312183mitoses
mitosis939633mitosis
molas75132093__molas
moolas83615593_moolas
nicols8810243nicol_s
nitons64614903nito_ns
ortolan747083ortolan
ortolans846553ortolans
payolas12148973payolas
pinoles93418703pinoles
pistoles102514723pistoles
pistols93213983pistol_s
pitas77427673pit__as
pitayas1286263pitayas
pitons85319043pito_ns
pittas86014523pit_tas
pyrolas1239863pyrolas
riojas1335813ri_ojas
rituals738353rituals
rugolas836373rugolas
scillas9310473sci_llas
scotomas1256263scotomas
sotols63714473sotol_s
stoas55126023_sto_as
stoles63927673_stoles
stomas84816323_stomas
talas55935893__talas
titles63719923tit_les
tittles73413253tittles
titular737523titular
titulars845863titulars
toeas55726423__toeas
togas67823003__togas
tola45236333__tola_
tolan55124013__tolan
tolans64319273__tolans
tolar55524113__tolar
tolars64817943__tolars
toles55147133__toles
tolls54728433__tolls
tolus55024483__tolus
toras55540373__toras
tritomas1048033tritomas
villas96117263vi_llas
viola85915543vi_ola_
viols86118103vi_ol_s
vitals94514303vital_s
vittles103211113vittles
vizslas1943143vizslas
wittols1035733wittol_s

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.406440125.6
2DLD Change Limit1340271836.19021652.2
3Display Results1831830.0762407.9
 (SQL Overall)1786911836.67226782.2
 
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.